Criteria

[Sam]

I crated a Query from a table. One field is called Item. On the criteria line
in the query I have [Enter Model Number] which gives me a pop up that says
that. If I type a item in there that item comes up. The issue I have is if I
do not type anything in the pop up I would like all the items to come up.

 

[kingston via AccessMonster.com]

Use this as your criteria:

Like IIF(IsNull([Enter Model Number]),"*",[Enter Model Number])

I crated a Query from a table. One field is called Item. On the criteria line
in the query I have [Enter Model Number] which gives me a pop up that says
that. If I type a item in there that item comes up. The issue I have is if I
do not type anything in the pop up I would like all the items to come up.