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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Paul Mars" <(E-Mail Removed)> wrote in message
news:OB$(E-Mail Removed)...
> 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

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

"Allen Browne" <(E-Mail Removed)> wrote in message
news:4080d783$0$16573$(E-Mail Removed)...
> 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.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Paul Mars" <(E-Mail Removed)> wrote in message
> news:OB$(E-Mail Removed)...
> > 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
>
>