Passing VBA variable in access query criteria

[ankita.sethi]

Hi,

I want to write a macro in Access (not VBA) and run various queries with the same criteria. This criteria is however not fixed and requires the user to enter the value.
Can anyone suggest me the best way to do this?

If I use VBA macro to prompt the user to enter the value once, how can I pass this value to each query that is run?

Please let me know if this does not make much sense and I will try to explain better :P

 

[krkilsdonk]

I think what you want to do is create a form that prompts for the criteria, and then add the form field to the queries. In the queries, use the notation [Forms]![FormName]![FieldName], where FormName is replaced by whatever you name the new form, and FieldName is the name of the field on the form.