Access 2000: Multiple values

I you are using bound controls then the best way would be to use unbound checkbox controls, and add a hidden text box that is bound to the field in question. Then on the click events of each check box, find the values of each check box and string them together and place the value of the string into the bound check box. In the form's Current event you would then need to extract the values from the hidden text box and update the values of the check boxes accordingly. You would need to develop youown strategy of how the data is stored in the single field, and extracted, (like seperating the values with a comma and using a loop and the Mid function to extract the data - which would mean always storing the data in the exact same pattern).
If there are only a couple of check boxes, then you may consider adding new fields to the table, one for each check box, or, if there are alot of check boxes, then create a seperate table, liknking it to the main table via a Primary and a foreign key. You could then chenge the query that gets the data to a inner join.

This question was closed by the author