I'm having dificulty figuring out how to process multiple check boxes on a
web form.
Let's say I have three check boxes:
cbox1
cbox2
cbox3
The only way I can think of to code the possibilities is something like:
If cbox1.checked = true then
..........
End if
If cbox2.checked = true then
.......
End If
If cbox3.checked = true then
.......
End if
If cbox1.checked = true and cbox2.checked = true then
.......
end if
If cbox1.checked = true and cbox3.checked = true then
.......
end if
And the If/End IFs go on forever!
As you can see, if I have around 8 check boxes, doing it this way could lead
to tremendous amounts of coding. I'm sure there's a better, easier way,
right? I thought of using a select case but that wouldn't be much better I
don't think.
The application is a query that runs against a single table in an access
database. Each check box represents each field they could chose from to show
up in a table or other style report.
TIA,
Jim