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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a macro to change a value in a record 1
Hard to explain - multiple update fields query... 7
How to adjacent field from a record 6
Calculating a field based on other fields in a form... 1
Summing Amount from Records with Yes checked off in Awarded field 3
two tables that are linked together 1
Count Number of Yes's in a Yes/No field 1
Yahoo new spam Tricks 3

Back
Top