troubleshooting Question

Run-time error 424 (calling a procedure)

Avatar of ilfocorp
ilfocorp asked on
Microsoft Access
5 Comments1 Solution601 ViewsLast Modified:
Hello programmers.  i am calling the below procedure from my first procedure. when i get
to  the "SET" line I get the error "Run-time error '424' Object Required.  I use the same recordset variable in the first procedure but i close and set it to nothing before calling this procedure.  I added the dims in the called procedure hoping that would make it see the object but no go.  Any suggestions.  thank you again.
Public Sub Update3009rpt()

    Dim rsQryCAvg As DAO.Recordset
    Dim rsTblRpt As DAO.Recordset
    Dim rsQryCAvgcnt As Integer
    DoCmd.RunSQL "DELETE tbl_ChkAvgRpt_3009.* FROM tbl_ChkAvgRpt_3009;"
    Set rsTblRpt = db.OpenRecordset("tbl_ChkAvgRpt_3009")
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros