Passing a value from a macro to a Query Criteria

[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

 

[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.