Create pre-designed report from an existing form

Viktor Lakics

Dear All,

I designed carefully a reasonably complicated report and a form. I use this
form for data entry and also for searching by setting various filters on
that form. What I would like to achieve is to have a button on this form
which could invoke the already designed report limited to only those records
which are filtered out on the form. I want to avoid designing a new form or
report, I want to use the existing ones.

My problem is that I do not know how I could write VBA code which could be
assigned to the button to limit the report to only those records which are
filtered on the form. Anyone care to explain?

TIA: Viktor

Nov 12 '05 #1

hal boyles

There are several ways to accomplish this.
A simple way would be to copy the report and save as "report2" then change
the record source for the report to be the same result set as the form.
Assign the new report to the new button.

Nov 12 '05 #2