Enabling Multiple fields after a combo box selection

johho0ha · May 9, 2007

I know how code to enable multiple fields after a check box selection. But I want to be able to do the same effect, but for a combo box. I want to dim all fields, then once I pick a selection from a combo box, the fields related to that selection would be enabled for data entry.

Here is the combo box selections:

T1
T2
T3
T4

based on which particular selection, I'd like to be able to enable the commands that are tagged that particular selection.

thanks

Jona

missinglinq · May 9, 2007

Something like this:

Code:

Private Sub YourComboBoxName_BeforeUpdate(Cancel As Integer)
   Select Case Me.YourComboBoxName.Value
      Case "T1"
        'Enable T1 controls here
      Case "T2"
       'Enable T2 controls here
      Case "T3"
        'Enable T3 controls here
      Case "T4"
       'Enable T4 controls here
   End Select
End Sub

Enabling Multiple fields after a combo box selection

johho0ha

Registered User.

missinglinq

AWF VIP

Similar threads

Users who are viewing this thread