Query by form question

[bllgnn]

I've got a form with 2 combo boxes that fill 2 invisible text boxes that my query looks to for criteria. One criterion is an autonumber field. Sometimes, the user wants to select all numbers, not just one. I've tried Is Not Null, but that doesn't work. Any suggestions?

 

[hermanlaksko]

Hi
Try Null, this should do the trick.

 

[GK22]

in the query put Like * & forms![formname]!cbo1, then you can select all

 

[bllgnn]

Hey GK22,

That works! Thanks.

Also, Hermanlasko, I tried using Null, but maybe I wasn't using it correctly. But thanks anyway.

As a newbie Access developer, I am very grateful for the help you fellow members are providing.

For instance, without the answer to my question, I had started to redesign my whole application because I thought that maybe you can't run a query from a form with more than one criterion, and allow the user to leave one of the criteria blank.

When I get better, I hope to contribute.