Three buttons launch my report, can the report know which and put it in the Title?

[Seamus59]

I have one report called by three different buttons with macro actions that have different "where" clauses. I'd rather not duplicate the report and change it's title so I'm trying to place a textbox in the report header whose control source can find the active control on the screen that called it.

Ive tried a number of options without success. I've checked dozens of forums also without and answer.



Thanks,
Sean

[June7]

In VBA, can pass a value to the report with the OpenArgs argument then the report can read that value in VBA function or textbox ControlSource (=[OpenArgs]). OpenArgs is the last argument of DoCmd.OpenReport (or OpenForm). VBA Help has more info. I guess macro has equivalent.

[RuralGuy]

The OpenReport command has an OpenArgs argument that can be used to pass values to the Report.

[Seamus59]

The OpenReport command has an OpenArgs argument that can be used to pass values to the Report.

Ahh, I totally forgot about OpenArgs! Thanks!

[RuralGuy]

You're very welcome. Glad we could help.