Query Criteria based off Form

[Jack W via AccessMonster.com]

Hi,

I've got criteria in my query to be based off a combo box of my startup form
which is linked to a table. It works fine, but how can I make it so it won't
use any criteria and display all records. My table has two columns, the first
is what is used for criteria, I thought if I made a new record and left its
value in column one blank it would be like having no criteria but this didn't
work. Any ideas/? Thanks in advance.

 

[Jack W via AccessMonster.com]

I changed my criteria in the query to use like(nz([my form field]),"*"))
rater than just [my form field], it seems to work ok, is this a workable
solution?

 

[Guest]

Try this:
Where FieldName Like nz(Forms![FormName]![FieldName],"*")