Default a field value on a form

[TAM]

I have a field called "qualified" for which the user has to select "yes/no". There's also an informational field which displays a position description. When the field contains a specific value, I want the yes/no field to be "No". How do I accomplish that? Is it an event?

if position_description contains "Associate", qualified value is "No" else leave the field blank for the user to select the required choice of yes/no.

 

[alansidman]

Use an after update event on the position_description control

If me.position_description = "Associate" then
me.qualified = "No"
End if

 

[TAM]

I don't believe it should make a difference, but this is a continuous form. I tried putting in the code below, but it's not automatically displaying "No" as expected. Should this code be in the table design?

Use an after update event on the position_description control

If me.position_description = "Associate" then
me.qualified = "No"
End if

 

[alansidman]

No. It should be in the form after update event for the control.