Creating a multiselect field in a form to populate a single field in a table

  • Thread starter Thread starter Conni
  • Start date Start date
C

Conni

Am wanting to include a single input field where multiple
selections are possible (checkboxes) and have this
populate a single field in the table. This field in the
table would contain anywhere from 1-10 values depending
on selections in the form. Can you tell me how to do this?
Also, how do I assign a text value to the multiselect
listboxes to be reflected in the table? I tried creating
an options box with checkboxes but this only allows a
single selection.
 
Please do NOT do this.

The design you describe may be okay in a spreadsheet, but it is completely
wrong in a database. Use a correctly normalized data structure, by creating
a related table where the values can be stored, one per row. It is then dead
easy to use a subform bound to this related table, where the user can select
as many options as apply, one per row, in the subform.
 
Back
Top