Combo Box1 Choice Enables Combo Box2


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
 
Ad

Advertisements

H

HServ

Solved this one on my own.
Turns out it that code would have worked but my values on the link table
were changed for "alphabetical order" and I wasn't aware. Hopefully that
code is helpful to someone because it turned out that it worked for me
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top