Adding an IF statement to a Macro

[Rick36]

I am trying to add an "If" statement into a macro:

If (local table 1)!(Field 1) = "YES"
Then Run Macro 2

I am unable to specify a specific field value within a table. The documentation specifies doing this using a Form or Report, but not a table. Is there a way to make the decision based upon a field value?

Thanks. . .

 

[Ranman256]

try using the full path to the field value:
forms!myform!txtBox