Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating Combo Box

Status
Not open for further replies.

Rseven

Technical User
Mar 7, 2006
41
US
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
 
How are ya Rseven . . .

How are you doing with this?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
afterupdate 1st combobox
setfocus to 2nd combobox
docmd.2ndComboBoxName.requery
 
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:


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!
 
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!!
 
Glad we could help!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top