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