Qry Based On CboBox Blank or Specific

[CharlesWhiteman]

Hi All, I'm trying to figure out the following:

I have a query and on my form a drop down box. I'd like the query to show all records if the CboBox is blank but narrow the query of a value is selected.

I've tried various including below but just cant seem to figure it.

Like "*" Or [forms].[FrmEventEngineering].[txtLocation]

 

[CharlesWhiteman]

Ok, I've figured out a good method using a module ModSearch whichmakes it really easy.