multiple parameter queries on opening form

[MKBRAD]

I have a report that is based on 4 queries that all have the same parameter
input form..I have the parameter form macro opening with the report, but how
do I open all 4 queries to supply the info to the report??

 

[Gina Whipp]

MKBRAD,

You can create a form that has a combo box and have that in the Criteria of
your queries... [Forms]![YourForm]![FieldOnForm] and then have a button to
call your macro to open your report.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm