Dynamic Combo Box

[Shaun3]

Hi all,

Thanks in advance for any and all help that can be provided!

I am completely new with access, so apologies in advance.

I'm designing a form which has two combo boxes on it: combobox1 and combobox1. Combobox1 selects values from the table "Categories", and combobox2 from the table "Subcategories". The tables are linked by a 1-many relationship (1 in category, many in subcategories).

When a selection is made in combobox1, how can i get combobox2 to only display the values in "Subcategories" corresponding to the selection made in combobox1? currently, as expected, all values in "subcategories" shows up in combobox2, regardless of the value in combobox1. any clues on how to change this?

Thanks again for any and all help!

-shaun

 

[pbaldy]

The concept is typically called cascading combo boxes. I have a little sample here:

http://www.baldyweb.com/CascadingCombo.htm

 

[Shaun3]

Thanks Paul!

I've downloaded your example and am studying it; the example is exactly what I want to do. Its slow going for a newb like me, so thanks for the help

-Shaun