access show/hide fields in query result

[seabell5]

I have a form built off of a query. On my form I have CHECK BOXES where I want the user to choose which fields to display. I am new to access and having a hard time figuring this out.

My query joins 2 tables. - CUSTOMER table, Customer Purchases. Tables are joined by Customer ID.

The CUSTOMER PURCHASES table column headings are Customer ID, PRODUCTS, PRICE, SEASON, YEAR ect...

I want the user to be able check on the form --what fields they want displayed. -

 

[randy700]

Take a look at the On Change event of your checkbox and the Visible property of the text boxes.


Randy

 

[seabell5]

When my query runs the data is displayed in DATASHEET view.

On the form if the user checks --- customer ID, season, product--only those columns show up in the datasheet view when the query runs. Another user might check -- customer ID, ans season. Then only those 2 columns will show.


SO how do I show or hide the query table columns the user checked?


Thank you so much for responding...

 

[MajP]

thread705-1457381