Copy Form Data To Report (All Records)

[Guest]

I have a database the runs a query using an unbound form in which users can
enter search criteria. The reults are returned in a form bound to the same
query. From that form I want to add a click button or whatever it's called
which can duplicate the data from the result display form in a report to have
a nice version for printing. I want to be able to preview the report before
printing. I've tried several different methods posted here and nothing seems
to work exactly right.

If I bind the report to the search query, and click the button on the form
to create the report, the query runs again and asks for search criteria all
over again. Although all records would be retuned properly this way, it
requires the user to search again.

I also tried not binding the report to the query and instead using
individual controls to retrieve each field from the form. This works, but
only retrieves the first record into the report.

Any suggestions on how I can get a carbon copy of all of my report records
and fields into the report? Thanks.

 

[Guest]

Hi -- I've recently built something similar to what you have but I used a two
forms and a report. The first form is the search form which includes several
combo boxes to use for search criteria; the combo boxes contain values from
the underlying tables. I also included an option group with two options: 1
to view in a form or 2 to view in a report. A command button is used to
launch the form or report.

I then construct a SQL string from the search criteria and use this to
filter the form or report to display the records which meet the criteria.

 

[Guest]

I need to understand your use of unbound form-- I know of-- Unbound
controls--Unbound reports--Unbound Text boxs. Could you be looking for a
Switchboard control to print your Query results? Do you have multi forms or
multi reports?