Changing recordsource

Hi

I have a report that thats record souce is from a query run from a form

I want to use the same report but run it from a different form using a a differnet query

How do i automatically change the record souce when the report is opened from my new form



code

Private Sub Report_Current()

If Forms![Vew all Invoices]![OrdID] > "1" Then

Me.RecordSource = copyofinv2

End If

End Sub



When I run the report from my new form i go to the original recordsouce .It dosnt change it in the proerty sheet

Changing recordsource