Multi-Select List Box

[dbnewbie]

Hi,
This is my first posting on this forum, and I would greatly appreciate any help with this issue...

I have a form that is used for entering information into tables. I would like to be able to select multiple options from a list on a form and have it saved into a table. Any ideas? Is this even possible

Here are some paths I followed:
The table has a List Box field, type Text, that gets values for the list items from another table. On the form, I have changed the Multi-Select property of the List Box to "Extended" so that the user can select multiple items from the list. But when I select items from the List Box, the table is not getting updated with the selected items.

Another way I tried doing this: The table has a List Box field that has no values (I'm not looking up values from another table). On the form, I set the Row Source of the List Box equal to the query that gets the list values from a table. I then set the Multi-Select property to "Extended". When I select multiple items from the List Box, the table doesn't get updated.

FYI: The control source for the list box on the form is pointing to the field in the table.


Thanks,
dbnewbie

 

[RichB]

Did you tell the listbox to store the data in a specific field?

 

[dbnewbie]

Thanks for the quick response.

Yes, the control source is pointing to a field on the table.
I have a list box on the form that is Multi-Select - Extended pointing to a field on the table that is Data Type - Text and a List Box with Row Source Type - Field List. The list box on the form is the one that is querying a table for its values.

So when I select items from the list on the form, I want these values to show up in the table in the list box field...


Thanks,
dbnewbie

 

[Tim L]

I think that you may be on to a loser here, unless you are heavily into prgramming, have a look at this posting and Pat Hartman's response:
http://www.access-programmers.co.uk/forums/showthread.php?t=85244

Tim

 

[dbnewbie]

Thanks Tim!!