Increase Efficiency

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

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
--
Dave Hargis, Microsoft Access MVP


"SGTPEP" wrote:

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