Selected Checkboxes

[shelti]

I have an Access form that contains a tabbed page titled Activities. This page contains 12 checkboxes relating to sports activities. The user is asked to choose their 3 favorite sports activities by clicking 3 of the 12 boxes.
The database has 12 separate fields (1 for each activity).
I would like to create a new field that will contain the name of each activity selected by the user (ie, fishing, hiking, bowling). I will then use this new field in a report. Any suggestions?

 

[jtmach]

In your report make a textbox. In the text boxes control source property type the following code.

=IIf([fishingCheckBoxFieldName]=True,"Fishing&quot

Replace fishingCheckBoxFieldName with the name of the field. The hardest questions always have the easiest answers.