Passing Input in Bracket [] To a Variable?

[mcl]

I use brackets such as [describe input I need] in queries to ask for input.
Is there anyway to pass the input to a variable so I can use that input in
other queries or even in multiple queries in a macro?

 

[Gina Whipp]

I use a form and have the queries look at the field on the form. That way I
can run multiple queries, reports from one field on a form

HTH,
Gina Whipp

 

[John Vinson]

I use brackets such as [describe input I need] in queries to ask for input.
Is there anyway to pass the input to a variable so I can use that input in
other queries or even in multiple queries in a macro?

The simplest way, as Gina says, is to use a Form. Your criterion would
change to

[Forms]![NameOfTheForm]![NameOfTheControl]

and you could put a command button on the form to run the macro.

John W. Vinson[MVP]