Expression pointing to a Macro

[Guest]

I have 2 fields in a report. I want to have an expression that looks to make
sure the 2 fields match. If they match I want a Macro to run. If they don't
match I want there to be a message that pops up stating they don't match. I
have tried numerous methods and have yet to get anything to work. Any ideas??

 

[David Conger [MSFT]]

You can use the Condition field in a Macro to evaluate and expression and
then decide what to do. So perhaps on the Report Load event you can fire a
Macro. Set the condition to [a] = where a and b are the fields that you
want to compare. Then for the action, chose RunMacro and have it call the
Macro you want to run. Of course, you could also build this condition to
the Macro you are calling.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **