Thread: Set value based on another value

I have a form that looks like this:

ScreenShot002.jpg

The Status field has 3 options to choose: Approved, Denied or Conditioned
If the user selects Denied or Conditioned, they need to select 1-3 Conditions (on the form: "Condition 1", "Condition 2", and "Condition 3").
How can I set the Condition 1, Condition 2 and Condition 3 to "N/A" if Approved is selected for the status?

I would use VBA programming, via the After Update event for Status.
If Me!Status = "Approved" then
Me!condition1.Enabled = FALSE
Me!Condition1 = "#N/A"
ELSE
Me!condition1.Enabled = TRUE
END IF