Multi Select List Results

[Deb Smith]

My forms contains 2 unbound multiselect list boxes, plus a number of other
fields. The first list box (LstContacts) contains all individuals in the
data base (potentially hundreds of people) and contains three fields
(LName,FName,MailName). The second list box (LstChosen) contains only those
records selected from the first list box.(This second list box could contain
from one to hundreds of records.)

I want to use the results from the second list box (LstChosen) to
automatically populate fields on the form so that the end user has a head
start on entering further information and does not have to enter each
individual separately.

All works well EXCEPT I cannot figure out how to move the selected records
from the LstChosen to the fields on the form.

Help please. Thanks in advance for any suggestions or help that can be
provided.

 

[Jeff Boyce]

Deb

When you say you want to move multiple (chosen) names "to ... fields on the
form", it sounds like you have a form that can hold more than one person at
a time. If so, does this mean you have tables that can hold more than one
person in one row (record) of data?

 

[Deb Smith]

Sorry for my lack of clarity....

The form I have is a continuous form. At the top of the form are the two
unbound list boxes. List box 1 (LstContacts) obtains its info from
tblContacts and contains three fields (LName, FName, MailName). The second
list box (LstChosen) contains only those records selected from the first
list box.

Each record of data below the list boxes on this continuous form will
contain information on one person. I want the information from LstChosen to
populate the first three fields of each record.The remaining fields on each
record will be fillled in by the user and come from a second
table(TblAttend).

Roughly, I want the form to look like this

LstContacts LstChosen

LName FName MailName LRequired NInvited
AttendStatus
(Populated by choices from LstChosen) (Entered by end user)

Is what I am trying to do possible? If it is, how do I get the information
and records selected from LstChosen to populate the first three fields of
each record on this continuous form?

Thanks in advance for any suggestions and help.

Deb

 

[Van T. Dinh]

You will need to construct a String from selected values in the ListChosen
to be used as the criteria for the Form Filter or the RecordSource of the
Form.

See The Access Web article:

http://www.mvps.org/access/forms/frm0007.htm

--
HTH
Van T. Dinh
MVP (Access)