report not showing filtered data (1 Viewer)

[philp107]

Hi All

I have a problem with reports (well the filtering). I have a form with multiple unbound textboxes to filter the data on the form, This all works fine. However when i click the button to create the report the filter does not apply, i am using
Me.Filter = Forms!Searchform.Filter
Me.FilterOn = Forms!Searchform.FilterOn
on the report side and DoCmd.OpenReport "myreport", acViewPreview, on the button.
I have not done access for a while and was probably not that good back then , any help would be appreciated

Phil

 

[bob fitz]

Try:
DoCmd.OpenReport "myreport", acViewReport, "", Me.Filter, acNormal

 

[philp107]

Try:
DoCmd.OpenReport "myreport", acViewReport, "", Me.Filter, acNormal

Hi Bob
Thanks for the reply but same issue.

 

[bob fitz]

Hi Bob
Thanks for the reply but same issue.

What is the value of Me.Filter when the code runs