Parameterized queries in macro

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hello,

I have three queries. All of them are parameterized query. (When running the
query, it will ask for the input from the user). All 3 queries are Update
queries.

When I run these 3 queries, I put in the same parameter for all 3. (Think of
it like I need to update a new same value in 3 tables.)

My idea is to put these three queries in a macro and run it. The problem is
that the macro will ask for the parameter 3 times (one for each query). How
I can create the macro so that it ask for the parameter just once?


Thank you,
B
 
Use an unbound form with unbound text boxes to enter the parameters. Them
reference the text box in the query like this --
[Forms]![YourFormName]![TextBox1]
 
Back
Top