passing filter in query to a report

[fedum]

Hi,
I have a query in witch I make a filter using vba

DoCmd.OpenQuery "qryProductenLeveranciers", , acEdit
Me.Filter = strFilterQ
Me.FilterOn = True
DoCmd.Close acQuery, "qryProductenLeveranciers", acSaveYes

Then I would like to print a report using this query with the filter.
Do I have to build the filter again when opening the report or can I pass the filter.
I thought that the filter was saved in the query by the acSaveYes but when I print then I get all the records.
I use a macro to print.

Thanks

 

[jedraw]

See this link

http://office.microsoft.com/en-us/access-help/apply-a-query-as-a-filter-HP001153865.aspx

 

[fedum]

Sorry jedraw, I would like to use a VBA code

 

[PHV]

Why not simply use the 4th argument of the DoCmd.OpenReport method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886