H
HServ
I have a combo box (combo1) on a form that is used to create a filter on a
subform. I'd like one of the choices from that combo box to enable another
combo box (combo2), which will also be a filter for the subform.
My question is, how do I assign values to individual choices in combo1 so
that only one choice (Recreation and Leisure) will enable combo2?
I borrowed this code from a dialog box that had an option group to enable a
listbox. If I could assign value=2 to one of the choices in combo1 it would
work:
' Enable Combo45 combo box if user selected Recreation and Leisure from
cboShowsup
Const conCategory = 2
If Me!cboShowSup.Value = conCategory Then
Me!Combo45.Enabled = True
Else
Me!Combo45.Enabled = False
End If
Help is greatly appreciated, Thank you
subform. I'd like one of the choices from that combo box to enable another
combo box (combo2), which will also be a filter for the subform.
My question is, how do I assign values to individual choices in combo1 so
that only one choice (Recreation and Leisure) will enable combo2?
I borrowed this code from a dialog box that had an option group to enable a
listbox. If I could assign value=2 to one of the choices in combo1 it would
work:
' Enable Combo45 combo box if user selected Recreation and Leisure from
cboShowsup
Const conCategory = 2
If Me!cboShowSup.Value = conCategory Then
Me!Combo45.Enabled = True
Else
Me!Combo45.Enabled = False
End If
Help is greatly appreciated, Thank you