Parameterized queries in macro

[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

 

[KARL DEWEY]

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]