I am using the following criteria in a query ... but records with a
value of NULL in the TableFieldName are being excluded.
Like [Forms]![FormName]![FormFieldID] Or IIf(IsNull([Forms]![FormName]!
[FormFieldID]),[TableFieldName])
For testing purposes, when using just the Is Null as search criteria
for the TableFieldName, I get results (i.e. records with a NULL value
in the TableFieldName are being returned).
However, when I want to use this search criteria ONLY on a Form, a
field is left blank, I get the message that the query is too complex.
Basically, if on a Form ... I leave a Text Field (being used as a
search criteria) blank ... I want to get ALL records regardless of the
value (NULL or not).
Anybody know how to get around this bug?
Thanks in advance.
Brad
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
