Multi Select in a list box

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

I'm trying to use a form as a method of simplified data
entry. One field requires the user to select multiple
items in a list box. I have set the MultiSelect property
to Extended but the selections disappear when I go to the
next record. If I set it to simple that selection is
copied to all records but if it's set on none, it works
fine. I don't know much about Visual Basic so is there any
way I can get around this problem without writing code? If
not, can someone explain how to enter the code (ie. what I
change to what).

Thanks
 
Using a multi-select list box to store the data means lots of code - in the
form's Current event, Undo event, and BeforeUpdate event at least. And the
end result is a poor design with inefficient and limited queriability.

Instead, create a 3rd able to store the choices. It will be a link between
the other 2 tables. If that idea is new, see this example:
http://members.iinet.net.au/~allenbrowne/casu-06.html

Once you have the tables set up correctly, create a subform where the user
can enter the choices one per row, using a combo box. No code is needed.
 
Back
Top