Check for field value as macro condition

[JustLJ]

Greetings.

Trying to set up a macro condition, so that if the value of a particular field in a table is "match" then that line of the macro will run.

I can't seem to get this to take table![tblname]![fieldname] = "match"; like the syntax shows for forms or reports.

I'd like to keep this as a macro condition so someone else can take over ownership/maintenance of this application.

IF the best way is a UDF, then I'll need some guidence on doing it to return a TRUE condition for the macro.

Thanks!
LJ

 

[JustLJ]

Worked out an answer based on bits and pieces I found around here...

In the macro Condition field:

DLookUp("[CompareField]","[tblName]","[CompareField] = 'not' &quot Is Not Null

_____________________________________
(means that the compare field is equal to 'not')

And for the action, do whatever you want to happen (in my case, runcode to do a bunch of system things).

Thanks everyone for being here on Tek-Tips for me.
LJ