List of Checkboxes on a form

[RLN]

Hello.

Re: Access 2003

I have a survey application that has 10 independent checkboxes on a
form (chkLawnCare, chkCarpetCare, chk DrivewayMaint, etc.)
One, or any combination can be checked before the form is submitted for
processing.
I need to do certain processes if checkboxA is checked, then other
processes if ChkBoxB is clicked, and yet a third set of processes if
ChkBoxC is clicked, etc.

How can I loop through the checkboxes on a form (regardless of
quantity; in case more are added later) and retrieve their names, then
do certain processes based on which ones are checked?

I'm trying to write this application with the vba code residing in vba
modules, rather than inside of the form object.
This is because I heard if you have VBA code behind your form and your
form gets corrupted, you lose the code too. Is this true?
If it is, I want to run this code in an independent vba module outside
of 'frmMain', but still reference the controls in this form.

I tried frmMain!chkBoxLawnCare but that does not work. What am I
missing?

Tips/advice are welcome.
Many thanks.

[pietlinden]

dim ctl as control
for each ctl in Me.Controls
if typeof ctl is checkbox then
'do something
end if
next ctl

I would use a subform (maybe with a bound combobox with
LimitToList=true) instead of checkboxes. Unless you're going to
perform some action if a checkbox is not checked.

You should also probably read Keri Hardwick's comments on surveys.
It's in this NG from like 6 years ago.

But then if you need to check each one, you could just do something
like
if me.chk1=True Then
'do something
end if