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

report

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


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