Passing a value from a macro to a Query Criteria

J

Jai_Friday

Good Morning,

I hope someone can help me,

I have happily working query that uses parameters values in the criteria for
a customer code,

I would like to setup multiple macro's that pass a different customer code
(per macro) to the query criteria.

Is this possible

Thanks in advance

Jai
 
K

KARL DEWEY

If you insist on using a macro instead of a picklist in a form then use the
SetValue action to set a textbox on an open form and then in turn use it as
criteria in the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Report, based on query, called from macro is prompting for param 1
Prompting for Criteria already defined in Report/Query. 1
change query criteria dynamically with value from a 2nd form 1
Using a Macro to change Query Criteria.... 1
Using a form to input update query criteria 2
Changing Criteria of a Query using a Macro or Visual Basic 3
Passing value to Query Criteria from ListBox 5
Passing Criteria From a Form 1

Top