Dynamically Change Recordsource of a Subreport

[TheSearcher]

If txt_Sex on Main Report = "M" then I want the recordsource of Subreport1 to be q_Male else q_Female.

If Parent!txt_Sex = "M" Then
    Me.RecordSource = q_Male
Else
    Me.RecordSource = q_Female
End If

Is this the correct code?
Do I place it in the subreport? If so, on which event?
Any help would be appreciated.

 

[theDBguy]

No guarantees but the using the Detail Format event to manipulate the subreport.

 

[TheSearcher]

I succeeded by placing the code in the "On Activate" event of the parent report.

 

[theDBguy]

I succeeded by placing the code in the "On Activate" event of the parent report.

Congratulations!