Rick Desrosiers
11-26-2001, 06:43 AM
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
11-26-2001, 08:07 AM
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]