How to show all Records...?

[Dezirous]

Hi eXperts........

I've a select query with criteria = department, when I select any one department at a time from my combo box, it shows records from that department.

Now I want to insert "All Department" option in combo box to show records from all department, not specific department. I don't know how to use IIF in query or somewhere else......

Plz help......... and many thanks in advance.........

 

[namliam]

Have a search on the forum for "search form" in the references part of the forum.

In those samples I am sure you can find the answer to this.