Updating Combo Box

[Rseven]

Hello,

I am trying to create a form that has a combo box with certain values for a given category and once a value is selected, a 2nd combo box gets populated with the sub-categories from the 1st combo box. Is this possible?

Thanks in advance

 

[dhookom]

Check the FAQs of this forum.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya Rseven . . .

How are you doing with this?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Mr Wonderful]

afterupdate 1st combobox
setfocus to 2nd combobox
docmd.2ndComboBoxName.requery

 

[missinglinq]

The concept is called "cascading comboboxes" although the exact same thing applies to Listboxes with the MultiSelect Property set to None, and the code is interchangeable. Here are a couple of links with examples:

http://www.fontstuff.com/access/acctut10.htm

http://bytes.com/forum/thread605958.html

If you Google the term along with the "Access" you'll probably get a gazillion hits!

Linq ;0)>


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Rseven]

Thanks for all the responses. I read the FAQ section and found what I needed and it worked like a charm.

Thank you all very much!!

 

[missinglinq]

Glad we could help!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!