One Prompt for same Parameterin a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several queries that all prompt for the same paramter, Year, which is
not going to vary within one run of the macro. When I run the macro, it
prompts me for the Year for every query where that parameter is needed. Is
there a way I can have the macro prompt for the parameter once in the
beginning and then just use that value for the year parameter for all the
queries that use it?
 
Denise,

On the form from which the running of the macro is triggered, put an
unbound textbox for the entry of the criteria. And then, in your
queries, in the place of the parameter prompts which you have now, put a
criteria like this...
[Forms]![NameOfYourForm]![NameOfYourTextbox]
 
Back
Top