468,257 Members | 1,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

report

I have a form, with subforms, wherein I use a filter to select certain
records.
Then I can browse trough the selected records, and, if nessecary, change
them.
The form is based on a table with primay key "EventID".

When finished, I want to open a report, based on the same table
How can I make my report only shows the records with those EventID's, that
exists in the form's filter?

txs
Johan
Nov 12 '05 #1
1 1679
In your form where you did your filtering, add a button that opens your
report. In the button's On Click event, add this code:
DoCmd.OpenReport "your Report's Name", acPreview, , Me.Filter. Go to the
properties of the report you want to open and in the "DATA" tab, set the
"Filter On" property to YES. After you have done your filtering in the
form, press the report button and you should see the report that includes
only the filtered data.

Denny G.

"Johan" <jo***********@pandora.be> wrote in message
news:q0********************@phobos.telenet-ops.be...
I have a form, with subforms, wherein I use a filter to select certain
records.
Then I can browse trough the selected records, and, if nessecary, change
them.
The form is based on a table with primay key "EventID".

When finished, I want to open a report, based on the same table
How can I make my report only shows the records with those EventID's, that
exists in the form's filter?

txs
Johan

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
6 posts views Thread by Bob Alston | last post: by
1 post views Thread by lorirobn | last post: by
1 post views Thread by monskie | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.