Another question for you guys regarding the PDF output file. I've naming the file 99% the way I want it to with this code:
Code:
DoCmd.OutputTo acOutputReport, "DSR_rpt", "PDF Format (*.PDF)", "\\one.mda.mil\Public\OPIR\Lab Ops (Formerly TSC)\Test Events\DSR Library\" & Format (Me.Event) & Format(Me.DSRLab) & "_" & Format(Me.DSRExecutionDate, "YYYY_MM_DD") & "_" & "DSR" & ".pdf", True
I'd like have the name of the event in the file name, but I don't have the event name on that form (it is in the DSR_rpt). How can I add the Event name to the file name when it is not in the form since I can't use Format(Me.Event)? I tried using Format (DSR_rpt.Event) and that did not work. I imagine that is because the report is be generated at the same time as the PDF so it does not know what DSR_rpt is yet.