Retriving a filter from TempVars

[Jim Stanicki]

I am modifing the Inventory templete from Microsoft. A form is displayed (inventory transaction list) and you can select a filter for the data. Also on that form you can select a report. I would like to have the report respect the filter. I can see that the filter string is being stashed in a TempVar but haven't yet figgured out how to apply it to the selected report. Any insights would greatly appreciated
Thanks

 

[Pat Hartman]

From within a filtered form, you can reference the filter -

SaveFilter = Me.Filter

 

[Jim Stanicki]

From within a filtered form, you can reference the filter -

SaveFilter = Me.Filter

Thanks Pat,
What I would like to do is use the same filter for a report. So if the form is filtered to show only blue widgets and the user prints a report it would only show blue widgets. I believe I can pass it with a TempVar like..
SetTempVar FilterString, Me.Filter
But how do I retrieve and apply the filter to my report.
Or is their a better way?
Thanks for your help
Jim

 

[Pat Hartman]

you can pass the filter in the OpenArgs argument when you open the report. In the report's Load event, you can apply the filter.

Me.Filter = Me.OpenArgs
Me.FilterOn = True