Multiple Queries requiring multiple selection

M

Mark

New problem, I have Macros that use 3 to 18 queries to produce the reports I
need. They work but are confusing to my co-workers because, with the 18 query
report as an example, they have to enter a number 19 times to produce the
report.\

This report is for mailboxes. I produce a sorted address listing by zip
code. In these mailboxes can be up to 19 compartment addresses per box. I
produce a query based on the first compartment in the box, then append every
address compartment to that list to make my total listing. So the macro has 1
openquery "make table" and 18 openquery "appends". They have to enter the zip
code 19 times to make this report.

Is there a way to have one entry, "zip code", entered once apply to all 19
queries?

Thanks for the help on the last problem.
 
R

Rick B

YEs, build a form and put a field on that form. Have the user make their
entry in that form. When they click a button on that form, have your
queries/reports run. DON'T close the form until after the report has
processed.

In your queries, take out your current crteria ([EnterMailbox]) and instead
put the following...


=Forms![MyFormName]![MyFieldName]
 
Top