Multiple Selection

  • Thread starter Thread starter Trigg
  • Start date Start date
T

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacement for multiple spreadsheets 3
Trying to reduce number of fields 0
Sorting Multiple Fields in Access 3
I swapped my CPU, how do I carry over all my programs and settings? 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
Lookup Tables and Multiple Values 2
Counting multiple memberships 1
Search form creation - Hoping for help bringing some old code to life 0

Back
Top