How to synchronize Access combo boxes...stuck

[bishop0071]

Here is my problem. I am stuck on how to set this up. Here are my tables:

tblCategories
tblExercises
tblSubCategories Back, tblSubCategories Biceps, tblSubCategories Triceps, etc.

tblCategories has one column:
Column name "Categories"
Shoulders
Core
Biceps
Triceps

All tblSubCategories has multiple columns with data underneath. Example:
tblSubCategories Back
Column name DB
Back Row
Column name TRX
TRX Rows
TRX Rear Fly
Column name Band
Band Rows

I need to create a form that has 3 combo box that is dependent on the other. For example:

If I pick Back from combo box Categories , the SubCategory combo box would have column names from that (DB, TRX, Band, etc)

Then the 3rd combo box would allow me to pick the exercises from the SubCategory combo box. So if I chose TRX it would list; TRX Rows, TRX Rear Fly, etc.

Any help on this would be greatly appreciated.

 

[John Big Booty]

What you are looking for is a Cascading Combo Box set. Also search this forum for further discussion as this a regular topic.