Queries codes for giving results as all if criteri is left blank

[shapman]

Hi

I have set up a form to run a query with the criteria linked to the options/drop down menus on the form. I am able to search for criteria set out in the combo boxes. However, what i would like to ensure is that if the drop down boxes are left blank the results will be to show 'all' results for that field.

help is greatly appreciated!

thanks in Advance!

Shapman

 

[Dennisk]

in the criteria field in the query place


=Forms!Yourformname!YourControlname OR Forms!Yourformname!YourControlname is null

Access will restructure this for you when you next open the query in design mode.

 

[shapman]

thanks! i will give it a try.

 

[Newbie100]

For the benefit of anyone who follows this thread and faces the same problem as I did, here's a link to my problem and solution.

http://www.access-programmers.co.uk/forums/showthread.php?t=135386

Hope it can help someone.