DoCmd OutputTo

  • Thread starter Thread starter data123
  • Start date Start date
D

data123

How do I correct the path name so it will reflect the field valu

DoCmd.OutputTo acOutputReport, "TEST1", "Snapshot Format",
"C:\=[FORMS]![PropertyAbbreviations].[PROPERTYNAME].snp", Fals
 
DoCmd.OutputTo acOutputReport, "TEST1", "Snapshot Format", _
"C:\" & [FORMS]![PropertyAbbreviations].[PROPERTYNAME] & ".snp", False
 
Back
Top