passing criteria from form to query

[Warehouseman]

I have a form with a list of all the fields in query. Each listed field has a
checkbox control beside it. I want the user to be able to select which fields
to display by putting a check mark in the appropriate box. How do I pass from
the form to the query which boxes have been checked to tell the query to
display only those fields in a report or Access spreadsheet?

 

[Duane Hookom]

I believe you need code that will build the full SQL of your query. Then use
DAO code to update the SQL property of your saved query. There is a sample
qbf applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that
performs something very similar.