Title...

[dbalargin]

I want to display a label or text box on the report header.
This label or text box will have a different caption pending on which button the users clicks on a form.
What can I do to make this happen?
ex. if cmdBucket is clicked ... then report label reads "Bucket 2"
if cmdTotal is clicked ... then report label reads "Totals"

 

[WayneRyan]

dbalargin,

You can make an invisible text box on your
calling form.

Each command button can fill it with the appropriate
caption.

In the On Open event of your report you can:

Me.lblMyLabel.Caption = Forms![YourForm]![YourTextBox]

hth,

Wayne

 

[dbalargin]

... thanks a plenty!
Works like a new washer.