Passing a parameters to a macro

[margo430]

I have a macro that executes several queries. In one of the queries I
prompt for a value to be used within my query. I would like to run my
macro without prompting for a value but yet retain that portion within
my query. How do I automate this process? Thanks.

Margaret

 

[Steve Schapel]

Margaret,

Probably the best way is to put an unbound textbox on a form, where the
criteria for the query is entered. Then, in the query design, replace
the parameter prompt in the criteria, with a reference to the value of
the textbox using syntax such as...
[Forms]![NameOfYourForm]![NameOfTextbox]