how do I pass a value to a mcro

[tonez90]

Hi I am using the ever standard alphabuttons macro that has been around for years. Is there a way of (on a form) entering into a text box someletters and passing that to the macro to fileter the records?

I am thinking of something along lines:
ApplyFilter LIKE *[forms]![mainform].[form].[inputetext]*

in a macro.

Or has someone done it better.
Yours in anticipation
Tony

 

[Mr. B]

I don't normally use macros but look at the macro command that opens a form. Part of the method of opening a form is being able to pass a filter.