URGENT!!!Is it possible to dynamically add new items to a list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that this can be done by using a combo box but I need to use a list
box so the users can select multiple items.

Any help would be appreciated.

Thank you
 
I know that this can be done by using a combo box but I need to use a list
box so the users can select multiple items.

Any help would be appreciated.

Thank you
Click to expand...

You can do it in exactly the same way that you change the rowsource
for a combo box.

It's simplest if you use a Table as the rowsource; just add a record
to the table (or delete one) and requery the listbox.

I take it you are aware that a multiselect listbox needs VBA code to
do anything with the selections? The Listbox doesn't have a "value"
that can be stored in a table or used as a criterion; you need code to
extract the selected values.

John W. Vinson[MVP]
 
Back
Top