Enable or disable a field based on entry in another field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields in my Data Entry Form (Field A & B). Field A is a dropdown
field with a list of values and field B is a memo field. If field A contains
any value other than "Other" than field B should be disabled (grayed out)
else field B should be enabled (not grayed out). Any help will be most
appreciated.
Thanks in advance.
 
On the OnCurrent event of the form and on the After Update event of the combo
write the code

Me.[MemoFieldName].Enabled = (Me.[ComboName] = "Other")
 
Back
Top