Increase Efficiency

[Guest]

Currently i have two seperate querys via a form.

One querys info from the a network of offices and the other querys on an
office by office basis using a combo box.

I would like to combine this so in the combo box there would be an option to
query all offices at once


Thanks

 

[Guest]

First, go to this site to see how to add "All" to a combo so the user can
choose that option:
http://www.mvps.org/access/forms/frm0043.htm

Now, in your query, put something like this in criteria row of the Office ID
field:

LIKE IIf([Forms]![MyFormName]![cboOffice] = "All", "*",
[Forms]![MyFormName]![cboOffice])

Of course, use the real names