Change Report RecordSource at Runtime

[Paul Mars]

MainForm has many different Buttons to open the same "MainData" Form with
different RecordSources using:

Private Sub RecordsAddressChildren_Click()
DoCmd.OpenForm "MainData"
Forms!MainData.RecordSource = "RecordsAddressChildren"
End Sub

Private Sub RecordsAddress_Click()
DoCmd.OpenForm "MainData"
Forms!MainData.RecordSource = "RecordsAddress"
End Sub

Then there is a button on "MainData" Form that opens a Report. The
RecordSource for the Report needs to be the same as the one just chosen for
"MainData" Form.

How can I do this?

Thanks,
Paul

 

[Elwin]

Create a global variable in a module

Public strRS as String

Set the variable with your command button's Click() event

strRS = "MyQuery"

Apply the value with your report's OnOpen() event.

Me.RecordSource = strRS

Reset the variable with your report's OnClose() event.

strRS = ""

 

[Paul Mars]

Thanks,
P

Create a global variable in a module

Public strRS as String

Set the variable with your command button's Click() event

strRS = "MyQuery"

Apply the value with your report's OnOpen() event.

Me.RecordSource = strRS

Reset the variable with your report's OnClose() event.

strRS = ""