Code for checkboxes ..

[Ssstacey]

Hi,
I have around 12 bounded checkboxes on one of my forms. By using these checkboxes, the user can indicate which statistics he would like to see in the ouput.
(I have created a table to which I bound the 'answers' of these checkboxes. )

Im trying to create a module that does the following:
verifies which boxes are checked and put the corresponding statistic in a set.
This set I would like to use to filter out the relevant statistics.

Is this possible? Can anyone point me into the right direction? So far, I dont have not come up with a useful code.

Thank you!
Stacey

 

[checoturco]

you can do with a query..

select ..... where <your_ckbox_field> = yes.


this brings you the records that are checked in you DB

 

[Ssstacey]

Im gonna try it..
Im not sure whether it will work cause the checkboxes are seperate fromt the records im selecting. Do u think i could use the where condition when 'my ckbox' is in a different table?
thanx
Stacey