I have a macro that opens a report corresponding to an active form, then sets the caption (SetProperty) of the report to a piece of information from the active form (which dictates the pdf name in the next step), then emails the report as a pdf, then closes the report. This works fine when manually run from the navigation pane. However, when I put a button on the form to call the macro, everything runs fine (report opens, emails, then closes) except the caption property is not set (pdf file name is not correct). I cannot figure out why the button fails in this regard, but manually calling the macro works fine.

Thanks for your help!