Passing a parameters to a macro

  • Thread starter Thread starter margo430
  • Start date Start date
M

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
 
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]
 
Back
Top