Making a report using Filter by Form

[Guest]

I'm generating reports from a database of 160 sets of data. I want to do
some reports on subsets of this data.

I used Filter by Form to set up a filter that correctly isolates one of
these subsets. Now I want to generate a report on this subset, but so far
have been having some trouble.

When I go to the toolbar and use AutoReport, the resulting report is
unfiltered. If I use the database window and generate a new report that way
it is also unfiltered. If I try to apply my filter to one of these reports,
I can't seem to use my existing filter but get offered to make another filter
instead.

When I use the help function it tells me:

With the filtered records displayed, click the arrow next to the New Object
button on the toolbar. And go from there.

Am I not displaying the filtered records correctly? I think I must be
missing something basic, but I am at a loss right now.

Any suggestions?

 

[Al Campagna]

finderril,
I had this same problem with an app.
The client wanted to (using filtering against the entire recordset) to send just those
clients a letter.
OR
If no filtering was done... just report on the current Client record.

In the report (the letter), using the Open event, this code accomplished that... (your
form must remain open)

Private Sub Report_Open(Cancel As Integer)
If Forms!frmCustomers.FilterOn = False Then
Me.Filter = "CustID = Forms!frmCustomers!CustID"
Me.FilterOn = True
Else
Me.Filter = Forms!frmCSNHCustomers.Filter
Me.FilterOn = True
End If
End Sub

--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."