Ok, I am very, very close to getting this to work. My problem now seems to be that my second combo box is holding onto the options from the first thing I selected in the first combo box and is not refreshing the options when I make a different choice in the first combo box. Am I supposed to...
I'm getting no options in my second combo box (cboSubcategory). The first combo box was not set as unbound so I corrected that first. Here's what I have in the rowsource of my second box:
SELECT tblCategoriesSubcategories.SubCategory
FROM tblCategoriesSubcategories
WHERE...
Your statement about setting the rowsource property of the second combo box to be a query that looks at the value of the first combo box as its parameter is exactly what I want it to do - I just don't know how. I know how to set up a query on the rowsource but I don't know how to make it look...
I have read a few articles on this site about having one combo box's selections limited based on the selection in another combo box. I've tried several times but the closest I can get is for it to perform like a parameter query - which is not what I want it to do. Anyone know what I'm missing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.