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