Urgent question...

  • Thread starter Thread starter Manoj
  • Start date Start date
M

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
 
Manoj said:
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?
Click to expand...

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.
 
Back
Top