Conditional data in form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set a field to only populate its formula if another field
returns a certain text.

(i.e. - run formula and populate Field 2 if Field 1 equals "yes", otherwise
leave blank. In this case, Field 1 is a combo box with three options.)
 
Set Field2's Control Source to:

=IIF([Field1]="yes",YourExpressionHere,"")

Careful, though. Although "yes" might display in the combo box after the
choice, the *value* of the combo box will be the corresponding value of the
Bound Column, which normally is a numeric primary key.

Hope that helps.

Sprinks
 
Back
Top