Activating a field when a condition is met

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
 
B

Beetle

Try this in the On Current event

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