Modifying Label Caption in VBA Code from Form?

[objNoob]

I have a form that opens a report, and before I open that report I'm trying to change the caption of a label on the report. I'm having troubles accomplishing this. The label is named lblFilter

I've tried...

Report_MyReport.Controls("lblFilter").Caption = txtDate.value

and...

Report_MyReport.lblFilter.Caption = txtDate.value




And, it just not working. I'm not sure how to reference that label's caption property properly.

[objNoob]

I just declared a public variable in the Report Code. Assigned the value to that variable from my form, and used the reports class open event sub to assign it to it's label control.

Baddabing!