View Full Version : How do you?


Tawcan
03-27-2003, 02:48 PM
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. :)