Query Wildcard for Primary Keys

[DeanFran]

I'm in the process of building a record filtering query tied to a search form. I've only done this once before, and I used the actual text (aka Name) rather than the Primary key for the search criteria, so I was able to get away with using a combo box and this in the query criteria

Like "*" & Form!frmSomeFormName!cboListOfThings &"*"

so that no selection returns all. Of course when you do that, and choose the Item with the primary key number of 1, you also get 10, 11, 12, 21, 31, etc. This is probably pretty basic, but how does one limit the query to only return the result for 1, AND return All if no selection is made in this case?

 

[DeanFran]

Stumbled upon this, and it seems to work. Am I on the right track?

Forms!frmSomeFormName!cboListOfThings OR Forms!frmSomeName!cboListOfThings Is Null

 

[pbaldy]

Yes, looks like you found:

http://www.theaccessweb.com/queries/qry0001.htm