listbox values

  • Thread starter Thread starter Miranda
  • Start date Start date
M

Miranda

Hi, i was wondering if someone could help me with this one. I have a form
with two combo boxes, a user selects values out of these combo boxes and
clicks an "add to list" button. On this click event, i want the selected
values to be put into a listbox (or any other kind of list if possible) on
the same form. So, the user should be able to add a whole heap of records to
the list box and then submit this later...i've tried using the set value
function, but can only get this to work for 1 entry in a combo box or text
field.

any help would be appreciated!
thanks
 
Listboxes can have their rowsource set to a recordset
(table or query), or to a value list.
Value lists are OK for small numbers of items.
I would recommend that you stay with a recordset.
The easiest way is to create a worktable that gets emptied
when the form opens. then as you select items, add then to
the table and requery the list. When the time comes to
submit, a simple append query from the work table to the
main table does the trick.
 
Back
Top