Am wondering if anyone knows of a way to create an ad hoc data query from a form, which also shows check boxes for all fields. Basically, I would like to have the user be able to check the data box for the fields they want to see, then run the query. The query would only display those fields checked.
I am assuming I could build a "super" query with all fields, and then use code in the form to select the fields as visible or not visible based on the check box result, but am not sure how to go about building the code.
Any suggestions? Thanks
I am assuming I could build a "super" query with all fields, and then use code in the form to select the fields as visible or not visible based on the check box result, but am not sure how to go about building the code.
Any suggestions? Thanks
