Error 3061, too few parameters expected 1 has occurred. 1

[craiogram]

I have added the following line of code to delete the row off my temp table that I have just finished with but am getting the error in the subject. I've never seen this can any offer any suggestions? It appears to be correct syntax wise.

CurrentDb.Execute "DELETE FROM tempTbl WHERE txtID = IDHold;", dbFailOnError

 

[ClydeDoggie]

I believe it is looking for IDHold. If this is a variable, you will have to put the value in the text (like "DELETE FROM tempTbl WHERE txtID=" & IDHold & ";"