Filtering In Reports

  • Thread starter Thread starter JoeW
  • Start date Start date
J

JoeW

Hey,
Alright, so I'm creating a database where filters are used quite
frequently. What I'm trying to do is have a button that the users
could click that would apply the current filters to a report, so that
then the report could be viewed as the is filtered on the form.

I read the MS Access help file I could find on this topic, but it
seemed as though it would require the user to enter the parameters,
rather than the report query just grabbing them off the form. Is there
a way to do this? To have the current filtered results exported to a
form? It would seem that would be a logical procedure.

I appreciate ahead of time any help anyone can offer.
 
Hey,
Alright, so I'm creating a database where filters are used quite
frequently. What I'm trying to do is have a button that the users
could click that would apply the current filters to a report, so that
then the report could be viewed as the is filtered on the form.

I read the MS Access help file I could find on this topic, but it
seemed as though it would require the user to enter the parameters,
rather than the report query just grabbing them off the form. Is there
a way to do this? To have the current filtered results exported to a
form? It would seem that would be a logical procedure.

I appreciate ahead of time any help anyone can offer.
Click to expand...

DoCmd.OpenReport "ReportName", acViewPreview, , Me.Filter

will apply the form's current filter to the report.
 
Thanks for your prompt assistance, just as your wrote this I was
reading more in the access help and stumbled across the same
information.

Thanks for your help!
 
Back
Top