Urgent question...

[Manoj]

In MS ACCESS 2000, i have created a list box which should allow user to
select multiple values from it and then store it in a table. Whatz the best
way to do this? What code is required for this?

Is there any way which can accomplish this without writing any code in VB?

Also, How can we add multiple values to a table?

Please reply ASAP

Thanks in Advance,

Sunny

 

[Rick Brandt]

In MS ACCESS 2000, i have created a list box which should allow user to
select multiple values from it and then store it in a table. Whatz the best
way to do this? What code is required for this?

Is there any way which can accomplish this without writing any code in VB?

Also, How can we add multiple values to a table?

You don't. At least not if you want a properly designed database. A field should
have one and only one value in it. If you need multiple values you add another table
and create a one-to-many relationship from the original table to the new one.

Multi-Select ListBoxes are not intended to be used to store multiple items in a
single field. The selections can only be retrieved by looping through the
ItemsSelected collection of the control using VBA code. They are typically used to
get multiple selections from the user so that the program can run some code acting
upon those selections. One "could" write code that would grab the selections and
stuff them into a field in your table, but that would be a perversion of proper
technique.