Record Source

[POM]

Hi all I will best for all thanks for help me

I have a report I want using for tow query by change record source like this code

Report_Qqtykam.Report.RecordSource = "Qqtykam"

but is not working please help me

 

[JHB]

If you open the report by DoCmd object, then you can use the OpenArgs parameter to transfer the recordsource name to the report.
And then in the report's open event set the reports record source.
Open the report by the DoCmd:

  DoCmd.OpenReport "YourReportName", acViewReport, , , , "YourReportsRecordSource"

Set the recordsource:

Private Sub Report_Open(Cancel As Integer)
   Me.RecordSource = Me.OpenArgs
End Sub

 

[POM]

Hello my friend very very very Thanks for you is was working I'm very haply
I wish the beast for you

 

[JHB]

Hello my friend very very very Thanks for you is was working I'm very haply

You're welcome.

I wish the beast for you

You too!
Beast = animal, creature etc.

 

[POM]

I'm so sorry my bro ,please forgive me
I wish best for you ,sorry again