Save open report with new name

I have opened a report in VBA and changed the font of some controls and now I want to save the report under a new name.

I only seem to be able to save it under it's original name with an instruction like

DoCmd.Save acForm, "New Employees Form"

But I want to save it under another name. How?

Please
Fritz PaulAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
This seems to work:

    DoCmd.OpenReport "report1", acViewDesign
    DoCmd.CopyObject , "Report1X", acReport, "Report1"

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.