I have a db which has a drop-down list with 3 options. When a user has chosen for option 1 I want to make it possible to fill in fields 1 and two.
When a user choses for the other options I want the user to see that the fields are grey and that they can't fill anything in.
I have no idea how to do this though. I would be so greatful if anyone could give me a hint as to what to do.
You need to put some code in the after update event of the combo box which contains the values you want to evalutate. For instance say the combo box name is 'cboMyCombo' and its values are 1, 2, 3. You would put code similar to the following in the after update event of the combo:
Select Case Me.cboMyCombo.Value
Case is = 1
ME.ComboNameToBeDisabled.Enabled = True
Me.SecondComboNameToBEDisabled = True
ME.ComboNameToBeDisabled.Enabled = False
Me.SecondComboNameToBEDisabled = Fasle