Copy prompted parameter to several queries run by the macro

  • Thread starter Thread starter Crispywafers
  • Start date Start date
C

Crispywafers

Is it possible to copy prompted parameter to several queries run by
the macro?

Meaning...

I have three macros that update the same table in different ways but
ask for the same parameter criteria [Specify Year].

The macro runs all three queries in order and therefore prompts for
[Specify Year] 3 times. Is it possible to have it prompt once, and
then copy that so that the last two queries don't ask the same
question.

Thanks!
 
Crispy,

No, not really. The easiest way to nandle this is to put an unbound
textbox on a form which will be open at the time that the macro is run,
enter the required year into this textbox, and then, in the criteria of
the queries, instead of the existing parameter prompts, you refer to
this textbox, using syntax such as [Forms]![NameOfForm]![NameOfTextbox]
 
Back
Top