How to use results from pass thru' query?

[Lara]

How can I use the results from a pass thru' query?
I wrote the following in vb -

Dim sSQL As String
Dim Result1 As String
sSQL = "<my select statement>"
Me.RecordSource = sSQL
Me.Requery
Result1 = Me.RecordSource

I get error for my pass thru' query and also
if this is the correct way to do it?

Thank you,
-Lara