Caption Setting

[Guest]

I want to set the caption value in a report to the value in a control on the
same report, or Form, Or Quirey. Iv'e tryed a Macro and a formula in the
caption field in the report's properties they dont seem to work. The purpose
of this is when I send the form via e-mail I want the attatchment to be named
as per a vaviable control on the report. ie order number Can any one please
help.

 

[Allen Browne]

You can set the Caption of the report in its Open event procedure like this:
Me.Caption = "Howdy folks"

Report_Open is the first event you can get at, but I think you will find
even this event is too late to change the name used in the attachment.