A Form field properties depend on Yes/No field entry

[rscott7706]

I am building a table that includes "Yes/No" and "Amount" fields.



So in my form design, I want two fields - "Yes/No", and "Amount" (initially deactivated).

If "Yes" is selected, I want the "Amount" field to be activated.

Now they can place the amount awarded in the "Amount" field.

If they select "No" (default field), the "Amount" field remains deactivated.

Is this possible?

Thanks!
Ron

[ranman256]

if using a combo box to pick yes/no:

sub cboBox_afterupdate()
txtAmt.enabled = lcase(cboBox) = "yes"
end sub

[rscott7706]

Thanks ranman256!!

[June7]

Or use Conditional Formatting to set Enabled property of textbox or combobox.

Is the form in continuous or datasheet view? Can record be saved with the Y/N field as No? User could return to the record and edit?