Report filter=form filter

  • Thread starter Thread starter Paul Mars
  • Start date Start date
P

Paul Mars

I have a form that has several different record sources. This form has a btn
to open a report. This report has the same record source as the current form
instance. I do this with:

Private Sub Report_Open(Cancel As Integer
Me.RecordSource = Forms!MainData.RecordSource

Now I just filtered the form instance. I thought I could then apply this
filter to the report by adding:

Me.Filter = Forms!MainData.Filter to the above code, but this does not
apply the open form filter to the report. How can I do this?

Thanks,
Paul
 
Did you set FilterOn to true as well?

Private Sub Report_Open(Cancel As Integer)
With Forms!MainData
Me.RecordSource = .RecordSource
If .FilterOn Then
Me.Filter = .Filter
Me.FilterOn = True
End If
End With
End Sub

That should work unless the form's filter has been set by using the
non-bound columns of your combos.

(You might also try saving the report with nothing in its RecordSource
property.)
 
thanks, that did it. Another question: Why did help not tell me this. I
looked up "Filter" and read all there was. Nothing about FilterOn.

Thanks again,
Paul
 
Back
Top