G
Guest
I have created search fields in forms before without issue. In the past, I
have always been searching for SOMETHING. This time one of the fields I have
is null some of the time, and when the user leaves this field blank, I want
all records to come up, including the records that have null values in this
field. ANYONE have any ideas???
Example:
Currently, in my form, when the user leaves a field blank, say the EntryDATE
field, my form puts an asterisk in the EntryDATE field when the user clicks
the SEARCH button. Then the query searches for the criteria:
Like "*"+[forms]![UserForm]![EntryDate]+"*"
This will bring up all records that have a date in this field. It will not,
however, bring up the records that have a null value in this field. Please
help!
have always been searching for SOMETHING. This time one of the fields I have
is null some of the time, and when the user leaves this field blank, I want
all records to come up, including the records that have null values in this
field. ANYONE have any ideas???
Example:
Currently, in my form, when the user leaves a field blank, say the EntryDATE
field, my form puts an asterisk in the EntryDATE field when the user clicks
the SEARCH button. Then the query searches for the criteria:
Like "*"+[forms]![UserForm]![EntryDate]+"*"
This will bring up all records that have a date in this field. It will not,
however, bring up the records that have a null value in this field. Please
help!