switch value based on condition

[awake2424]

Is it possible to create a VBA on the AfterUpdate() that flips a value based on a condition?

For example, if in a text box (Gender) there is a value of "Male" and in a combo1309 the value is "No", can Gender be switched to "Female" automatically?

 IF Me.combo1309 = "No" Then 
              Me.gender....

Thanks.

 

[burrina]

Try this:

If Me.comb01309 = "No" Then
Me.Gender = "Female"
Else
Me.Gender = "Male"
End If

HTH