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

Multiple Select Listbox in MS Access

P: n/a
Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table? I created a form based on a select
query that joins the parent and child records, but it's not an obvious
solution. I'm sure it's easy though, any links?
Jan 25 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bb*****@gmail.com wrote:

I'm not quite following your scenario, but suffice to say a
multiselect listbox cannot be bound. You will have to select items in
code.
For a one-to-many solution the more typical implementation is a
form/subform.

-Tom.

>Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table? I created a form based on a select
query that joins the parent and child records, but it's not an obvious
solution. I'm sure it's easy though, any links?
Jan 26 '08 #2

P: n/a
Oh. I have one subform already, so the idea would be to put this
subform inside another subform?
On Jan 25, 10:29 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bbcr...@gmail.com wrote:

I'm not quite following your scenario, but suffice to say a
multiselect listbox cannot be bound. You will have to select items in
code.
For a one-to-many solution the more typical implementation is a
form/subform.

-Tom.
Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table? I created a form based on a select
query that joins the parent and child records, but it's not an obvious
solution. I'm sure it's easy though, any links?
Jan 28 '08 #3

P: n/a
On Mon, 28 Jan 2008 04:48:49 -0800 (PST), bb*****@gmail.com wrote:

You can, but that creates a UI most suitable for experienced users.
The alternative is to have two subforms, with the second one showing
the subrecords of the first one.

-Tom.
>Oh. I have one subform already, so the idea would be to put this
subform inside another subform?
On Jan 25, 10:29 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bbcr...@gmail.com wrote:

I'm not quite following your scenario, but suffice to say a
multiselect listbox cannot be bound. You will have to select items in
code.
For a one-to-many solution the more typical implementation is a
form/subform.

-Tom.
>Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table? I created a form based on a select
query that joins the parent and child records, but it's not an obvious
solution. I'm sure it's easy though, any links?
Jan 29 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.