Multiple Selection

[Trigg]

I want to be able to have a Look Up field that allows me
to select more than one choice. I have figured out that
you can accomplish this with a sub-form but I would rather
not do that.
Any suggestions?

 

[Allen Browne]

The subform is by far the simplest solution. The choices really should go
into another table related many-to-one, and the subform is ideal for that.

If you enjoy writing code, you could use a multi-select list box. Use the
form's BeforeUpdate event to loop through its ItemsSelected collection to
write the concatenated string to your field. You also have to parse the
field and set the correct selections in the Current event of the form, and
rest the list box selections to the OldValue of the concatenated field in
the form's Undo event.