Public Sub myProc()
Dim sSQL As String
Dim conn As ADODB.Connection
Dim rs As New ADODB.Recordset
Set conn = CurrentProject.Connection
rs.Open sSQL, conn
If Not rs.EOF Then
Debug.Print rs.Fields(1).Value
End If
rs.Close
Set rs = Nothing
Set conn = Nothing