Pick Fields from an Input Form

[Guest]

I am used to using a form to allow users to “filter†info from a query for a
report, so they can for example pick a choice from a drop-down to limit
records to those that match the choice in a particular field.

I would like to do something similar but in this case list field names with
a check box. If the user checks the field name, then that field will be
included in the report. But I’m not sure how to accomplish this. Is this
something that can be done in the query grid or via some other method?

Appreciate any help. Thanks.

Steve

 

[Guest]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
allows you to add a few objects to your database to allow users to select
fields and build queries. The results of the query are a couple clicks away
from sending to Excel, Word, CSV, HTML, Print, Word Merge, Graph,..