On an access form I want to have a control array of checkbox's that will only allow 1 checkbox from the control array to be selected. The count of checkbox's on the form and the caption's of the checkbox's need to be driven from a query recordset which contains a name and a value.
Depending on which checkbox is selected I will run an event using the value from that checkbox. Below is the query I want to build the checkbox's on the form
SELECT campaign.name, campaign.status, campaign.campaignID
The campaign.name field would be the caption of the checkbox, the campaign.status would be whether the checkbox was checked or unchecked, the campaign.campaignID would be the value that I would use to relate back to the record in order to update the campaign.status field.
Please help with the VBA needed to make this happen, I have searched online but cant find anything close to what I'm trying to do.