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