Access related list boxes

[mikevds]

I have a music database created in Access.

I have lookup fields for CD Group and CD Name
Do I need a autolookup Query or Syncronized combo box to perform the following function.
Filter by Form
CD Group
Select from List box
CD Name only Display CD's related to that Group

Mormon Tabernacle Chior Cd Group
Only display CD's related to the Mormon Tabernacle Chior
NOT ALL RECORDS IN THE DATABASE.

I've bent my self backwards on this and get no were I know it might help me with some visual basic coading.
The only resources I have is some books on Access
I Live in a Rural Area and there are no computer coarses near me that fit my time.

This following procedure I think would be done for example with any Products Database let's Say like Bakery Items
NAme of Company
Nabisco
NAme of ITems
Crackers
Cookies
Only display products by each item Name
NOT ALL RECORDS IN THE DATABASE WHICH ARE BAKERY ITEMS IN THE LIST
wHEN I FILTER BY FORM

PLease email me at
mikevds@optonline.net
So somebody can get back to me on this
I can even send you some screen shots if you don't get what I am getting at.

 

[Mile-O]

PLease email me at
mikevds@optonline.net

Er, no. If I want to get back to you on this I'll hit the reply button.

The search term you need is Cascading Comboboxes. There are so many examples and posts on this topic you should find what you are looking for.