report updated with the result of a query

[nianko]

Hi Forum,



I have a select query, a form with a combo box (based on the select query) and a report (also based on the same query).
When I select the name of an investor in my form through the cbo, the latest securities bought by this investors are displayed. I would like ot be able to print the result of this filter so I created a report with the following [event procedure]:

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

But I have an error:

Run time error 424
Object required

What is the problem

Thanks

[pbaldy]

Try

Me.RecordSource = Forms!frmLookUpByInvestors.RecordSource