Hello All,
I am using the following code to send a report to the "FSGs" folder on the C drive. I will like to instead send to the attachment field of the record using command5 button, can anyone point me in the right direction please.. Thanks in advance.
Private Sub Command5_Click()
On Error Resume Next
Dim fileName As String
Dim filepath As String
fileName = "Activity Report"
filepath = "c:\FSGs" & fileName & ".pdf"
DoCmd.OutputTo acOutputReport, "DailyActRpt", acFormatPDF, filepath
End Sub