DoCmd OutputTo

[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

 

[Duane Hookom]

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

 

[data123]

Thanks I new it was something simple