Multiple Values in a list box

[Gal]

Hi everybody.
If anyone can tell me how can I choose multiple values in
a list box (by using ctrl or shift buttons) and store
them in a table.
Obviously, since there is only one field for it in the
table, the program won't let you do it. Any suggestions?

Thanks

[Albert D. Kallal]

The problem is where will you put the multiple values?

Since you can't, (and should not) stuff more then one value into a field,
the a listbox is not the best control to use. Worse, is how will you handle
when users go back to that record, you will somehow have to "high light" the
select options.

The usual solution is to create a another table that is related to the
record. This is classic one to many relation. You thus use a sub-form to
allow more then one selection, or item to be added. Often, this means that
you will use a sub-form with combo box to allow easy selection. Not quite as
user friend as a listbox, but you can make the whole in work without one
line of code...so it is a lot less work.


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
[email]kallal@msn.com[/email]
[url]http://www.attcanada.net/~kallal.msn[/url]