By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Create pre-designed report from an existing form

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.