Create a multi-select list box with a NotinLIst procedure

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hi

I would like to create a multi-select list box that will allow the selection
of multiple values. I would also like to include a NotInList procedure that
will add new values if needed.

The list box is based on a separate table which I called LB_actions.

Is this possible? Also, how do I sort the entries after new entries have
been added?

Thank you in advance
 
Hi

I would like to create a multi-select list box that will allow the selection
of multiple values. I would also like to include a NotInList procedure that
will add new values if needed.

The list box is based on a separate table which I called LB_actions.

Is this possible? Also, how do I sort the entries after new entries have
been added?

Thank you in advance
Click to expand...

A List Box does not permit the entry of a value not already in it's
list, nor does it even have a NotInList event.

In general, you would need to use an text control (on a form) to first
enter the new value into the [LB_actions] table. Then use the text
control's AfterUpdate event to requery the List Box Rowsource (which
should be a query, not the table itself. You can sort the query on
whatever field you wish).
 
Back
Top