I have a form (Search) that has a datasheet (BasicInfoQuery) in it as a subform. I have set the criteria of the first field of the BasicInfoQuery to reference a combo box (Serial) on the Search form. This works fine. The criteria for this is:



[Forms]![Search]![Serial] or [Forms]![Search]![Serial] Is Null

I then have the datasheet on the Search form set to requery when the Serial combo box updates. Like I said this works fine. The problem came when I put the criteria into the second field of the BasicInfoQuery. I used the same criteria, only this one references a combo box called Model:

[Forms]![Search]![Model] or[Forms]![Search]![Model] Is Null

I set the datasheet to requery after the Model combo box updates. For some reason it seems that the query is ignoring the criteria on the second field. When choose a value from the Model combo box, nothing happens. Also, when I open the query directly, a pop-up box asks for a serial value and then another asks for the model value. Even entering the value into this pop-up, the query does not filter.

Any ideas? Why would the first criteria work and not the second?