Clarkie001
IS-IT--Management
Can anyone tell me why I am getting Run Time error 3265 Item does not exist in this collection with the below sql.
Seems to be the last line (in red) that the error falls on, any help would be greatly appreciated
Clarkie
db.QueryDefs("Report_Builder").SQL = "SELECT tblReports.tbl_ID, tblReports.Report, tblReports.Description," & _
" tblDeveloper.Name, tblDeveloper.Contact_No, tblDeveloper.Email, tblOwner.Name, tblOwner.Contact_No," & _
" tblOwner.Email FROM tblOwner INNER JOIN (tblDeveloper INNER JOIN tblReports ON tblDeveloper.tbl_ID" & _
"= tblReports.Developer) ON tblOwner.tbl_ID = tblReports.Owner WHERE (((tblReports.tbl_ID)=" & strID & "))"
Seems to be the last line (in red) that the error falls on, any help would be greatly appreciated
Clarkie
db.QueryDefs("Report_Builder").SQL = "SELECT tblReports.tbl_ID, tblReports.Report, tblReports.Description," & _
" tblDeveloper.Name, tblDeveloper.Contact_No, tblDeveloper.Email, tblOwner.Name, tblOwner.Contact_No," & _
" tblOwner.Email FROM tblOwner INNER JOIN (tblDeveloper INNER JOIN tblReports ON tblDeveloper.tbl_ID" & _
"= tblReports.Developer) ON tblOwner.tbl_ID = tblReports.Owner WHERE (((tblReports.tbl_ID)=" & strID & "))"