|  | ComboBox with Sub lists | | |
| | | Nied, E |  |
|  Posted: Fri Aug 29, 2008 9:35 pm Post subject: ComboBox with Sub lists |  |
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] | |
| | Posted: Fri Aug 29, 2008 9:47 pm Post subject: Re: ComboBox with Sub lists | |
Here is an example, using listboxes. They are not bound to data, but could
be easily made that way:
LINK
--
Arvin Meyer, MCP, MVP
LINK
LINK
LINK
"Nied, E" <Nied, E@discussions.microsoft.com> wrote in message
news:58D50716-CD72-4C65-A23F-CA6817BD7D5C@microsoft.com...
| Quote: | 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! |
|
| |
| | | Nied, E | |
| | Posted: Tue Sep 02, 2008 9:40 pm Post subject: Re: ComboBox with Sub lists | |
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?
"Arvin Meyer [MVP]" wrote:
| Quote: | Here is an example, using listboxes. They are not bound to data, but could
be easily made that way:
LINK
--
Arvin Meyer, MCP, MVP
LINK
LINK
LINK
"Nied, E" <Nied, E@discussions.microsoft.com> wrote in message
news:58D50716-CD72-4C65-A23F-CA6817BD7D5C@microsoft.com...
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!
|
|
| |
| | | Nied, E | |
| | Posted: Wed Sep 03, 2008 9:43 pm Post subject: Re: ComboBox with Sub lists | |
| |  | |
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!
"Nied, E" wrote:
| Quote: | 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?
"Arvin Meyer [MVP]" wrote:
Here is an example, using listboxes. They are not bound to data, but could
be easily made that way:
LINK
--
Arvin Meyer, MCP, MVP
LINK
LINK
LINK
"Nied, E" <Nied, E@discussions.microsoft.com> wrote in message
news:58D50716-CD72-4C65-A23F-CA6817BD7D5C@microsoft.com...
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!
|
|
| |
|
|
