On the form I created there are two Combo Boxes (SelMainWONum and SelServWONum), both are set as Disabled.

If the check box (GasMain) gets checked the SelMainWONum becomes enabled and If the check box (GasService)
gets checked the SelServWONum becomes enabled.

The problem I am having is when I check either box the combo box is enabled for all records even if a box in a
a record is not checked.

For example:

If I check GasService all the combo boxes for SelServWONum become enabled.

If I go to a new record that does not have either box checked and click on a field in that record without checking a box then both SelMainWONum and SelServWONum go Disabled.

Any help or suggestions would be greatly appreciated


Private Sub Form_Current()
If Me.GasService = True Then
Me.SelServWONum.Enabled = True
Me.SelMainWONum.Enabled = False
Me.GasMain = False
ElseIf Me.GasMain = True Then
Me.SelServWONum.Enabled = False
Me.SelMainWONum.Enabled = True
Me.GasService = False
Else
Me.SelServWONum.Enabled = False
Me.SelMainWONum.Enabled = False
End If
End Sub

Private Sub GasMain_Click()
If Me.GasMain = True Then
Me.SelServWONum.Enabled = False
Me.SelMainWONum.Enabled = True
Me.GasService = False
Else
Me.SelServWONum.Enabled = False
Me.SelMainWONum.Enabled = False
End If
End Sub

Private Sub GasService_Click()
If Me.GasService = True Then
Me.SelServWONum.Enabled = True
Me.SelMainWONum.Enabled = False
Me.GasMain = False
Else
Me.SelServWONum.Enabled = False
Me.SelMainWONum.Enabled = False
End If
End Sub