I need assistance with Access VBA

Hi experts,
I have a Access application and I am getting an object not set error message in the following line of code:  

Me.subForm.Form.Recordset = adoRS

I have included part of my entire sub below, please let me know what I am doing wrong.  Thanks in advance,
mrotor

Private Sub cmdSearch_Click()
    Dim strSQL As String
    Dim strSQLW As String
   
    Dim adoRS As New ADODB.Recordset
    Dim adoCN As New ADODB.Connection
    Dim adoCmd As New ADODB.Command
    Dim strItems As String
    Dim strConn As String
   
    '******* Get the assocaite info from the db *******
    strConn = modConnTools.fL50_GetConnString("FAEAGLE")
   
    With adoCN
        .ConnectionString = strConn
        .Open
    End With
   
    With adoCmd
        .CommandText = "SELECT TaskName, Topic, ProposedFutureState, ModelOfficeReporting, FASSTAppSpreadsheet FROM dbo.TestData WHERE Topic = 'PRG'"
        .CommandType = adCmdText
        .ActiveConnection = adoCN
    End With
   
    'Set the cursor location to client
    With adoRS
        .CursorLocation = adUseClient
        .CursorType = adOpenStatic
        .LockType = adLockBatchOptimistic
        Set .Source = adoCmd
        .Open
    End With
   
        Me.subForm.Form.Recordset = adoRS
       
    'Disconnect the recordset
    Set adoRS.ActiveConnection = Nothing
    If adoCN.State = adStateOpen Then adoCN.Close
mainrotorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
change this

Me.subForm.Form.Recordset = adoRS

with

Set Me.subForm.Form.Recordset = adoRS

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.