Using a choice in a combo box to disable controls

[mooneye]

I am trying to disable controls on a form based on the value on display in a combo box. The value changes as I search through records through records and I am trying to disable controls depending on what value is currently stored by the field related to the combo box.

 

[SkipVought]

hi,
Here's a way to do it wherever strTriggerValue is selected, CommandButton1 greys out...

    If ComboBox1.Text = strTriggerValue Then
        CommandButton1.Enabled = False
    Else
        CommandButton1.Enabled = True
    End If

Skip,
metzgsk@voughtaircraft.com