Create a report based on table field selections

[yellow24]

I want to create a form that has selection buttons which then creates a
report. I would like to have selection buttons that if selected, pulls that
data onto the report. For instance, the table has these fields: building
number, building name, funding resp., storage type, smoke detector, sprinkler
system. Say someone only wants to see the building number, name and storage
type on the report. They select the buttons for those fields, click on
another button to create the report. How do I create the selection buttons
to include only those fields on the report and how do I create the report
based on those fields? I don't know visual basic, so please, be very
specific with your reply! Thanks in advance for your help!

 

[Duane Hookom]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows users to select fields, set sorting, apply criteria,... Results are a
couple clicks from sending to print, Excel, Word Merge, WOrd Table, and other
formats.

 

[yellow24]

This looks like what I'm trying to do. How do I create it in my database?

Thanks!

 

[Duane Hookom]

I think there are instructions on the main form.
=========================
Data sources are created by building queries from your tables and saving
them with names beginning with "<". This allows you to join several tables,
group by, alias field names, and hide other complexities of your data.
Typical data source query names might be "<Customers>" or "<Third Quarter
Sales>".

Users will have the ability to choose a data source and then select fields
from the data source for their "report".

To use this "applet" in your applications, import all of the objects except
the sample tables. The only tables required are zstblQBFFields and
zstblQBFSource. Delete the records from these tables after importing. If your
application is split into a front-end and back-end (it should be), move the
tables to your back-end mdb."
=========================