I have studied the questions already listed for several hours now and I still keep receiving an error even after several redrafts of the code. Forgive me I haven't written SQL embedded code in VBA at all so some of the more basic points I am missing.
I am trying to delete records from a permanent table (JobhMTItem) which match the records listed in a temporary table (TbxResequenceJohMTItem). The code I have written is listed below, the "strSQL" string is on one line:
Dim strSQL As String
strSQL = "Delete JobhMtItem FROM JobhMtItem INNER JOIN TbxResequenceJohMTItem ON JobhMtItem.Id2 = TbxResequenceJohMTItem.Id2"
CurrentDb.Execute strSQL, dbFailOnError
The above code fails with the following error:
"Error number 3128 - Specify the table containing the records you want to delete"
I have tried to match this to other answers provided by the experts to achieve similar results but I cannot see where I am going wrong. Any help would be appreciated.