Running Multiple Queries With Same User Input (1 Viewer)

[Rick Desrosiers]

I Have multiple queries that need to be run one after the other and use the same parameters for all of the queries. I would like to be able to have the user input the information one time instead of multiple times. Can someone point me in the right direction.

Thanks

 

[jwindon]

Create an unbound form with unbound controls that the user will enter the criteria into. Create a command button(s) on your form to execute your query or series of queries, etc. VBA code can be added to the command button to do several other things.

Reference these controls in each of your queries.

i.e.

=Forms!UnboundSearchFormName![UnboundControl4CriteriaName]