How do you?

[Tawcan]

Link queries to reports dynamically so different queries will call up depending on the # that's entered?

Queries:
12345678 Page 1
12345678 Page 2

23456789 page 1
23456789 page 2

Report 1 -> can be linked to either one depending on the # entered.
Report 2 -> same as above.

Right now my report is linking to tables dynamically using this code:

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2
End Sub

(Forms![INDIVIDUAL APR]!Box2 is where the # is on the form)

I tried using
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2 Page 1
End Sub

but that gave me an error....

Any helps would be much appreciated. Thanx.