Hi there,
I have a Report that runs from a Query, query looks for existing records (ID), then displays them on screen. Report just puts the Query in a nice presentable way (formatting). I am still coding, but the idea is to have the report to be able to run by user (no ribbons, no commands, no controls, just the report button to open/run it). That being said, When the report is run, it calls the query, parameter popup comes up, I entered the value and I get the values on screen with a command button I added to the Header. I thought it was as simple as:
Private Sub Command13_Click()
DoCmd.OutputTo acOutputReport, "test", acFormatPDF, "c:\OF_test.pdf"
End Sub
but everytime I run it (click command button), it always gets the error 2501, The OutputTo action was canceled, any ideas??
Many thanks!