Re: Not sure I can do this.

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mon, 22 Aug 2005 15:00:10 -0700, "Karen53"
<Karen53@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Ofer,
>
>The record needs to hold multiple business units for each record and I need
>to be able to filter on each. A field only holds one value from a list box.
>Am I understinding a list box correctly?
>

You need ANOTHER TABLE.

A Field cannot hold multiple values, of course. You have a one-to-many
or many-to-many relationship; consider using a Subform rather than a
listbox for data entry. A multiselect listbox cannot directly store
data in a table - you need to write VBA code to loop through the
selected items and store them. Doable but a subform is much simpler!

John W. Vinson[MVP]
.