Export report to PDF Automatically with button

[godknow]

currently i have to open my report and export manually to save report as pdf.
This is my code to open for specific user :
DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID

now I want to output my report to pdf automatically to a certain location.

how do i filter with specife userid ... by using DoCmd.OutputTo
DoCmd.OutputTo acOutputReport, "myreport", acFormatPDF, "C:\Users\public\temp\Course " & [UserID] & " - test.pdf", False

is there any other way i accomplish this..

 

[KenHigg]

You should be able to filter the underlying query -

 

[godknow]

You should be able to filter the underlying query -

Can you explain with an example ... I don't understand " You should be able to filter the underlying query

 

[godknow]

Any way to do this

 

[pbaldy]

If you keep both lines, you should get a filtered report.

 

[CJ_London]

modify

DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID

to

DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID, acHidden

then run your OutputTo

OutputTo does not allow you to use openargs, if you don't want to use OpenReport to provide them then you need to modify your query as previously suggested or have a bit of code in the report on open event to provide the filter

e.g.
Me.Filter="[User_ID] = " & Forms!YourFrm!User_ID
Me.Filteron=True

 

[godknow]

modify

DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID

to

DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID, acHidden

then run your OutputTo

OutputTo does not allow you to use openargs, if you don't want to use OpenReport to provide them then you need to modify your query as previously suggested or have a bit of code in the report on open event to provide the filter

e.g.
Me.Filter="[User_ID] = " & Forms!YourFrm!User_ID
Me.Filteron=True

Thanks this works ...