Paired List Box (and unrelated: append qry)

H

Heidi

How do I create a paired list box? Microsofts help menu on this absolutely
stinks! I have my main list creating and including (using an append qry) the
fields I want in my table, but I want a list box right next to it that shows
the records I just added.

Also while I'm at it - I have this list adding these values when I click a
command button and appending these to a table, but I'm having some trouble
with a combo box holding a chosen date I want to also include on each record
that is appended. Example: form is for an rsvp. Combo box reflects the dates
held in a table - user chooses a date to rsvp the list of people for. List
box below holds all possible attendees. Click on attendee, click command
button to "rsvp" which references append qry and appends to table. Problem
is, date will only work for one record - not for each name that is appended
to the table. I want the date to be added to each record in the table.

Thanks,
Heidi
 
Top