Hi,
I want to base my query on checkbox values from a form and then automatically opens a report that shows the query result. How do I detect checkbox values and how do I put it in my query dynamically and link it to report? There are more than 15 checkboxes in the form. I can't do 15 if then statement. Plus there are combinations of answers. Is there any code example/web site there I can refer to?
Thanks a lot!!!
I want to base my query on checkbox values from a form and then automatically opens a report that shows the query result. How do I detect checkbox values and how do I put it in my query dynamically and link it to report? There are more than 15 checkboxes in the form. I can't do 15 if then statement. Plus there are combinations of answers. Is there any code example/web site there I can refer to?
Thanks a lot!!!