468,512 Members | 1,625 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,512 developers. It's quick & easy.

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 3568
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

Pre
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
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.