Macro based on populated field

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

Recently someone ask, and was answered, how to run a macro
dependant upon another populated field within that form
(i.e. "if this field is x then run this macro otherwise
run this other macro"). How would one do it if what one
wanted was "if this field is x then run this macro,
otherwise do nothing"?

Thanks in advance
 
the "Else..." argument of an If statement or IIf() function is optional.
just don't include it.
 
Susan,

Just put the equivalent of...
[TheOtherField]="x"
.... in the Condition of the relevant macro action. That's all. There
is no need for any "otherwise do nothing" consideration to be applied.
If the Condition is met, the macro will run, if it's not, it won't.
 
Back
Top