Using VBA to manipulate properties in a Report

[adacpt]

Hello,
Using VBA, I need to change the values within the following Report properties:

Format - Caption

Event - OnClick

Data - RecordSource

It seems like this would be easy, but I can't find examples of the specific commands. I appreciate the help.

[June7]

Can't change a report once it is rendered. Some properties can be changed before the report renders with code in report OnFormat or Open events.

This example changes the RecordSource to a string passed to the report with OpenArgs argument of DoCmd.OpenReport:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Nz(Me.OpenArgs, Me.RecordSource)
End Sub

Here is the code that opens the report and passes sql string to the report:
DoCmd.OpenReport "SampleList", acViewPreview, , , , Me.ctrSampleList.Form.RecordSource

Try setting the report caption in the report Open event.

Why would you need to change property of OnClick event? The event code should be written to handle parameters passed to the report. Where is the OnClick event?