listbox values



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

any help would be appreciated!




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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads