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]
 

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

Too few parameters. Expected 1. 10
Calculating a field based on other fields in a form... 1
How to adjacent field from a record 6
Ask not 8
two tables that are linked together 1
If Greater than when a formula Results in N/A 2
MS Access problem 0
Field entry dependent on another field value 2

Top