ComboBox with Sub lists

[Nied, E]

I'd like to create a ComboBox that has entries that when clicked on can provide
a list of choices related to the entry originally clicked on and store that
value in a table. Hope this makes sense!

Access 2007

Thanks for any help!

 

[Arvin Meyer [MVP]]

Here is an example, using listboxes. They are not bound to data, but could
be easily made that way:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Nied, E]

Arvin,

Thanks for the info - very helpful. If I want to store the selection in a
'master' table, do I make the listboxes bound to that table?

 

[Nied, E]

Arvin,

If you happen to get this - the example you sent works well. I would like
to have the values of both listboxes populate my master table fields. I can
get the product name but the catagorie uses the ID number instead of the
description. That's ok if I could write a query against the master table and
sub the ID with the description but haven't been successful. Can you help
again?

Thanks!