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

Using MultiSelect List Box on a Subform

P: n/a
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.)
tblContactIssues (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
tblContactIssues.

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 tblContactIssues.

Please help,

Jonathan McLean


Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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!
Nov 12 '05 #2

P: n/a
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********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
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!
Nov 12 '05 #3

P: n/a
"Jon McLean" <jm**********@earthlink.net> wrote in message news:<5_*****************@newsread3.news.pas.earth link.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.
Nov 12 '05 #4

P: n/a
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********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"Jon McLean" <jm**********@earthlink.net> wrote in message
news:<5_*****************@newsread3.news.pas.earth link.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.
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.