Using MS Access/cascading combo boxes


QUESTION: I have two combo boxes which are set up first one category, second one subcategory. When the selection in the first is changed the second (subcategory) correctly changes to list only the few items available. I cannot though, select anything from the list in the second combo even though I can see the choices.

ANSWER: What is the controlsource of the second combo?

Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

[an error occurred while processing this directive]---------- FOLLOW-UP ----------

QUESTION: the control source for both boxes are blank. The row source for both boxes are as follows -

Category (combo1):
SELECT [Supplier Category table].CategoryID, [Supplier Category table].CategoryName, [Supplier Category table].SupplierID FROM [Supplier Category table] ORDER BY [Supplier Category table].CategoryName;

Subcategory (combo2):
SELECT [Supplier Subcategory table].SubcategoryID, [Supplier Subcategory table].SubcategoryName, [Supplier Subcategory table].CategoryID FROM [Supplier Subcategory table] WHERE ((([Supplier Subcategory table].CategoryID)=[Forms]![Addition Request Form]![cat comb])) ORDER BY [Supplier Subcategory table].SubcategoryName;

One table (Suppliers) and one form (Suppliers/Subcontractors) were made up originally before these combo boxes were required hence two new underlying tables with basic category and subcategory info.

ANSWER: If its an unbound combo then it should be selectable. Is the locked property set to yes?

Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

---------- FOLLOW-UP ----------

QUESTION: No they're both set to No

I don't have a clue why the second combo shouldn't be selectable. The only thing I can suggest at this point is to upload a copy of your database. You can post at where you can attach a zipped copy. Or post it to a cloud storage like SkyDrive and send me a link.

Include a synopsis of the situation and the name of the form causing the problem.


Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2017 All rights reserved.

[an error occurred while processing this directive]