Nick Reck said:
I am struggling to use the Multiple Select List box to let the user select
multiple options, and keep finding that the multiple selections change
every
record, and do not clear when I go from record to record. DO I NEED TO
USE
CODE to do this. The help has not helped me!
You've had an answer to your detail question.
But, as a general rule, you can go a long way without using code other than
code that the wizards generate, provided you choose the right "subset" of
Access (obviously MSLBs are not in that subset). One of my colleauges was
pressed into service as a "database guy" by the public school district which
employed him as an engineer.
Back in the early 1990s, he re-created in Access and enhanced a database
orginally done by someone else in dBase in the 1980s. It has, he says, "No
code except what was generated by the Wizards" and has been used for
ordering and tracking distribution of food and supplies in the districts
Food Service ever since. It is still used today, long after he retired.
No code means "no error handling" but he is a very thorough, methodical, and
detail oriented person whose application anticipates most possible errors
and avoids them... for example, letting people enter a value by typing in
text often leads to errors and mismatches; letting them choose the value
from a Combo or Listbox prevents the typographical errors and mismatches.
Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP