471,108 Members | 1,351 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Create pre-designed report from an existing form

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
1 3629
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.

Similar topics

3 posts views Thread by Neal | last post: by
7 posts views Thread by Alan Illeman | last post: by
reply views Thread by Jon Slaughter | last post: by
reply views Thread by Jim | last post: by
14 posts views Thread by Schraalhans Keukenmeester | last post: by
37 posts views Thread by Steven Bethard | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.