Using MS Access/cascading combo boxes

Advertisement


Question
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,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA


---------- 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,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

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

QUESTION: No they're both set to No

Answer
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 askmehelpdesk.com 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.

Scott<>

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

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

Experience

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

Organizations
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

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.