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

On Thu, 25 Mar 2010 09:25:01 -0700, forest8 wrote:

> 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

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).
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail