S
Susan L
I have developed a Search form that provides several different criteria that
users can select from combo boxes. The search results form is based on a
query called Search. I found the following code/criteria statement that was
working well until I added code for Null values.
=[Forms]![frm_Search]![cboStatus] & "*"
I had this criteria statement in several fields in the query and it seemed
that I could enter criteria in more than one control and/or leave the
criterion blank and the correct records would be found when I clicked the
button on the Search form.
Then I entered the following addition to one of the criteria combo boxes for
which I wanted to return all records if nothing was entered.
=[Forms]![frm_Search]![cboStatus] & "*" Or [Forms]![frm_Search]![cboStatus]
Is Null
Now a search produces absolutely nothing! My search results form is blank. I
tried removing the Is Null stuff from the query -- tried creating a new
query. Nothing works. I've doubled checked to make sure that the proper query
is the Record Source for the Search Results form. Can anyone shed some light
on this?
users can select from combo boxes. The search results form is based on a
query called Search. I found the following code/criteria statement that was
working well until I added code for Null values.
=[Forms]![frm_Search]![cboStatus] & "*"
I had this criteria statement in several fields in the query and it seemed
that I could enter criteria in more than one control and/or leave the
criterion blank and the correct records would be found when I clicked the
button on the Search form.
Then I entered the following addition to one of the criteria combo boxes for
which I wanted to return all records if nothing was entered.
=[Forms]![frm_Search]![cboStatus] & "*" Or [Forms]![frm_Search]![cboStatus]
Is Null
Now a search produces absolutely nothing! My search results form is blank. I
tried removing the Is Null stuff from the query -- tried creating a new
query. Nothing works. I've doubled checked to make sure that the proper query
is the Record Source for the Search Results form. Can anyone shed some light
on this?