By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

connected comboboxes

P: n/a
I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav

Dec 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,

I asked a similar question a while ago and someone helped by responding
with a good example. They used a city/state example where the user
selects a state in one combo box and only that states cities are
displayed in the second combobox. Rather than give an example myself I
think its only fair to let the orignal poster have the credit, so
search the past posts for my username and you should come accross the
original reply :0)

Ste
Parasyke wrote:
I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav
Dec 7 '06 #2

P: n/a

Parasyke wrote:
I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav
here's an article that explains it...
http://www.mvps.org/access/forms/frm0028.htm

save a link to the site. Most people here use it all the time.

Dec 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.