List or Combo or something else for Multiple Choice

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

In forms view, how can I choose more than one multiple choice. Right
now I set it up in a list form in the table. I was unable to pick more
than one of the choices. Can you help me? Thank you in advance.
 
If you want to store multiple choices for a record in your table, you *must*
create a related table, so each record in this table can have multiple
matches in that one. You will then interface this with a main form for the
main table, and a subform where you can enter multiple rows for the multiple
choices.

If you are not trying to store multiple matches but merely use them for
filtering a form or report, and you are comfortable with VBA, you can use a
multi-select list box for this task. Details in:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html
 
Back
Top