Parameter queries. Duplicate Prompts

G

Guest

I run macros which open several parameter queries. Often each of these
queries requests the same data e.g. Enter Month. Every time a query opens I
have to supply the month. Is it possible to supply the month when the macro
first opens and apply this to all subsequent queries?
Thanks in advance
 
G

Guest

Open the queries from a form, on the form create a text box to input the month.
in all the queries create a reference to this text box instead of parameter

Select * From TableName Where FieldName = Forms![FormName]![TextBoxName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top