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")