Full Version: show data in another combo box based on a field in another combo box in ms access
UtterAccess Forums > Microsoft® Access > Access Forms
werice
I have two comco boxes one combo box shows the main categorys and the other combobxo shows the sub categories. They bot pull from the tables maincategory and subcategory.
x:
Maincat has maincatid maincatname
100 arts and entertainment
200 automotive
Subcat table has: maincatid subcatid subcatname
100 15 Acting Schools
100 16 Actors
100 41 Aerial Photographers
200 66 Airport Parking
200 87 Antique & Classic Auto Dealers
200 88 Antique & Classic Auto Restoration & Repair
The thing is, say a user chooses maincat 100 in the maincat combox I only want the three subucategories associated with maincat 100 to display in the subcategory combobox but at this time all main and subcategories display in the subcategory combo how can I set the subcategory to display only the subcategories associted with the maincatgory chosen?
Thanks
theDBguy
Hi,
Welcome to Utter Access!
What you are describing is called a "Cascading Combobox." Take a look at this tutorial to learn how to create it.
Hope that helps...
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.