Form To Select Query Output Fields

[mdray00]

Hi Guys,

I have an access database and I have a used a form so that the user can input variables into a query.

What I would like is to have a form that has all of the fields on the query so that the user can tick or untick fields that they would like to see in the query output.

I am guessin that in the VBA code somewhere it would be something Query name then query field and then show or hide
but I dont know that syntax. Could any1 help with this.

Many thanks

Mike

 

[KenHigg]

Mike, Here's a hint: You'll need your code to build the sql statement from scratch each time it executes.

MySQLString = "Piece one of your sql statement" & "Piece two of your sql statement" etc...