Automatically filter a report and generate PDF (1 Viewer)

[Mr. SLP]

I have figured out how to open a report and filter it in reference to a list box and I have figured out how to automatically save a PDF by clicking a command box. However, I can’t figure out how to made a command box automatically filter a report and then save it. Suggestions?


Sent from my iPhone using Tapatalk

 

[pbaldy]

It may help if you show your working code. In general, if you open a report with a wherecondition and then use OutputTo, the output file will be filtered. Your code would be along the lines ofL:

DoCmd.OpenReport...
DoCmd.OutputTo...
DoCmd.Close...

You can open the report hidden so the user doesn't see it flashing by.

 

[nardimrk]

sound not bad! i will try