Activating a field when a condition is met

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

I Have two fields in a form

i) Awarding body registered which is a yes/no field (drop down list)
ii) Awarding Body Reg Number which is a number field

what i would like to do is only allow information to be entered into the
'Awarding body Reg No' field when the Awarding body registered field is Yes.

plaese can anybody help.

Thank You
Iain
 
Try this in the On Current event

Me![Awarding Body Reg Number].Enabled = Me![Awarding body registered]
 
Back
Top