Change query based on user selection

[arrrghhh]

Hello,

I'm trying to get Access to display a specific set of subcategories, once a main category is chosen. I have all of the categories in a table, and the main category selection is very easy. What I'd like to have is a list or combo box that is only visible when a main category is chosen that has subcategories associated with it. Obviously the subcategories would also change when the main category is chosen.

What's the best method to do this? I'm not very skilled with Access, if there's any good how-to's I'm open for suggestions as well. I've been doing a lot of reading, but nothing that I've found is thorough enough. Thanks!!

 

[genomon]

Have a look here: faq702-4289

Cogito eggo sum – I think, therefore I am a waffle.

 

[arrrghhh]

Excellent, thanks for your reply.