goldmedallist
Registered User.
- Local time
- Today, 12:49
- Joined
- Jun 24, 2005
- Messages
- 16
I am trying to generate a query that shows the data that the user indicates via check boxes.
What I did is a form (GenerateQuery) which lists down over 30 fields with their respective checkbox. When the query is run, it will open up another form (All details) with the massive froms in DS views but hide those field that are not checked.
For each checkbox that is checked, I have the follow code
**
If Forms!GenerateQuery.CheckClientName = True Then
Forms.Alldetails.ClientName.ColumnHidden = False
End If
**
First of all, I am not sure if this would even be the most efficient way of generating a query. Any advice would be most helpful.
The question I have is how to reset all the columns to .Columnhidden = true before I run the query everytime? Do I need to write 30 statements of the above and set them = true (initially all are hidden)? Or would there be a quicker way?
Thanks!
What I did is a form (GenerateQuery) which lists down over 30 fields with their respective checkbox. When the query is run, it will open up another form (All details) with the massive froms in DS views but hide those field that are not checked.
For each checkbox that is checked, I have the follow code
**
If Forms!GenerateQuery.CheckClientName = True Then
Forms.Alldetails.ClientName.ColumnHidden = False
End If
**
First of all, I am not sure if this would even be the most efficient way of generating a query. Any advice would be most helpful.
The question I have is how to reset all the columns to .Columnhidden = true before I run the query everytime? Do I need to write 30 statements of the above and set them = true (initially all are hidden)? Or would there be a quicker way?
Thanks!
