IF this field say YES, then I want other fields to be INACTIVE

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Please forgive me, but I am new to access 2003 and this is probably a
no brainer. I built a form and this is what I am looking for it to do.

When a person selects from a drop down box YES, then I want other
fields to become INACTIVE/GREY or for it to say "N/A"

Can anyone help in the simplest of laymen terms? Thanks!
 
If your are looking for a simple layman, that would be me.
First point, If the only options in your drop down (called a combo box) are
Yes and No, I would suggest using a check box instead. Checked = Yes, Not
Checked = No or in VBA code it would be True and False. You use the Enabled
property of the text box to grey it out. Use the After Update of the combo
or check box.
For the combo that returns yes or no:

Me.MyTextBox.Enabled = Me.MyCombo = "No"

For a Check Box
Me.MyTextBox.Enabled = Not Me.MyCheckbox


Regardless of which
 
Back
Top