Trying to send a report to a subfolder

[Gina Maylone]

Hello again folks!



I am trying to output a report (in pdf format) to a subfolder on my hard drive. I cannot figure out the proper syntax to get it into the subfolder - I can get it into the main Project folder - but not the Proposals subfolder. The folders are created at the beginning of a bid.

'On Error GoTo Err_Command245_Click
 
Dim stDocName As String
Dim myPath As String
 
stDocName = "ProposalReport"
myPath = (Forms!proposals!FullPath + gc1name + stDocName)
 
 
DoCmd.OutputTo acReport, stDocName, acFormatPDF, myPath + ".pdf", True
 
 
 
'Err_Command245_Click:
'MsgBox Err.Description
 
End Sub

Note: I have commented out my error handling to eliminate the issue I was having with the runtime error "the output to action was cancelled".

Right now, I grab the full path from a text box on my form: FullPath=[workingdir] & [jobinfo] Results in: C:\Clients\Customer Name\E14-2695 December 3 Job Test\Proposals. Workingdir comes from: =Left([CurrentProject].[FullName],InStrRev([CurrentProject].[FullName],"\")) and jobinfo from:=[Forms]![proposals]![JOBID] & " " & [Forms]![proposals]![JOB NAME] & "\Proposals".

Any help will be much appreciated!

[June7]

Does the string have all necessary back slashes, such as the one following Proposals?

[Gina Maylone]

AH-HA! Thank you June7 (again)! That's exactly what was missing.