Using MultiSelect List Box on a Subform

[Jon McLean]

I fear that my question may be elementary, but what I am trying just is not
working.

I have two tables:

tblContacts (Essentially a mailing list. Each contact has an Autonumber
ID.)
tblContactIssue s (Just an issue ID as long integer and ContactID as long
integer to correspond with tblContacts. I want to capture multiple issues
of interest for each contact)
tblIssues (Autonumber IssueID and Description)

On the form where we enter the contact info (frmContacts) I want to be able
to select multiple issues that will create multiple records in
tblContactIssue s.

I am trying to get a MultiSelect List Box on a subform to work, but it seems
to only allow one record per ContactID in tblContactIssue s.

Please help,

Jonathan McLean

[Pieter Linden]

Any reason you can't use a combobox on your subform and choose the
values from the dropdown? If you use a MSLB, you'll need to cycle
through the ItemsSelected collection and write the values to the table
in code... Way too much work, IMO... easier and more intuitive to just
use a combobox in your subform... If you use a listbox and make a
mistake, how would you delete/correct it? PITA!

[Jon McLean]

I need to be able to make multiple selections of issues per each contact.
Can I do that with a combo box?

Jon
"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com...
Any reason you can't use a combobox on your subform and choose the
values from the dropdown? If you use a MSLB, you'll need to cycle
through the ItemsSelected collection and write the values to the table
in code... Way too much work, IMO... easier and more intuitive to just
use a combobox in your subform... If you use a listbox and make a
mistake, how would you delete/correct it? PITA!

[Pieter Linden]

"Jon McLean" <jm**********@e arthlink.net> wrote in message news:<5_******* **********@news read3.news.pas. earthlink.net>. ..

I need to be able to make multiple selections of issues per each contact.
Can I do that with a combo box?

Jon

Okay, makes sense now. There's a one-to-many relationship between
contacts and issues (or many to many). So you would just have the
contacts as the source of the main form and issues the source of the
subform... then you could have your comboboxes there and choose until
you're blue in the face.

[Jon McLean]

Pieter,

Thanks for the advice. However, this is still only allowing me to save one
issue per contact. I need the table tblContactIssue to store multiple
instances of ContactID with different IssueNos.

I saw a db that did this. If the user clicked the box (I think a list box
but maybe a combo box) and chose an option the option would stay visible,
and for each issue chosen a new record would be created with ContactID and
IssueNo.

I made a combo box on a datasheet subform, and I got a similar effect, but
it would not record the IssueNo at all. I changed it to a form view form
and I can only select one issue. Going back into the same contact record
and selecting a different issue replaces the original ContactID record with
a different issue.

I have seen it done, I am just missing something.

Thanks for the help,

Jon McLean
"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com...
"Jon McLean" <jm**********@e arthlink.net> wrote in message
news:<5_******* **********@news read3.news.pas. earthlink.net>. ..

I need to be able to make multiple selections of issues per each contact.
Can I do that with a combo box?

Jon

Okay, makes sense now. There's a one-to-many relationship between
contacts and issues (or many to many). So you would just have the
contacts as the source of the main form and issues the source of the
subform... then you could have your comboboxes there and choose until
you're blue in the face.