Jun 1 2005, 08:32 AM
Is there a way to use a check box on a form to control the visibility of a field of data in a query?
Example> I have a query "X" with 5 fields of data. I have a form with 5 check boxes on it, one representing each of the fields in the query. What I would like to do is be able to check or uncheck the boxes on the form to control what fields of data are visible or not visible in query "X".
Thanks in advance for your help.
Jun 1 2005, 08:56 AM
am I understanding you right that you are trying to hide fields in queries?
No one should be able to even see the query or query structure besides the db admin who designs it.
You should use forms or reports to show your query results. Then you can hide/show the fields on the form which are based on the query fields with your checkboxes.
Jun 1 2005, 10:07 AM
Sorry for not explaining the end result of all of this.
What I am ultimately trying to do is create a custom export form so that the user can select a few fields out of dozens of fields to export to excel or a text file.
So, I have a query which contains all possible fields to export and I want the user to be able to chose, through a form and checkboxes, which fields they wish to export. This is a much more complex function than just displaying the fields in the database.
Jun 1 2005, 10:36 AM
I guess another way of looking at it is constructing a query based on field choices made on a from.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here