So I was messing around with it and realized that the date in the filename is coming up as "mm/dd/yyyy" and the / are the problem. Any way to change it to a - or a .??
The message box appears with the correct file location and name but I am still getting the output error. This would create a new file, would that cause the error?
I double checked the spelling and it all looks good, I did notice I had the same combo box in the expression twice, here is the updated
="P:...\Merch Database\" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" & [Forms]![USER PAGE]![Text67] & ".pdf"
I am still getting an error...
Im wondering if it is possible to use the ExportWithFormating macro with an Output File dependent on a combo box and date picker located on separate forms. the expression I have right now isnt working
=P:...\Merch Database" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" &...