Sounds like either a variable is misspelled or missing.

Show us the error.
What line is highlighted?

Now I'm getting a syntax error, but it's the same line that was giving me the original error.
I uploaded the error message, the line in question and the file layout of TPR10bD39DocIndex.

Try moving your SQL statement into a string and statusing it before trying to execute the query. That will show you what Access is working with:

Details

StatusBox = ""
Status "Indexing..."
' AbortBtn.Visible = True

Dim S as String

S = "DELETE FROM TPR10bD39DocIndex WHERE TPR10bDocID = " & TPR10DocID
Status S

CurrentDb.Execute S
Copy

I would be looking at the Primary Key and use the NZ Function in case a Null value is returned.

CurrentDb.Execute "DELETE FROM TPR10bD39DocIndex WHERE TPR10bDocIndexID=" & Nz(TPR10DocIndexID,0)

That shows TPR10bDocID as being empty

Kevin, when I try your suggestion i get the same results.

I notice that the forms Record Source is TPR10aD39Doc, and that file does not contain TPR10bDocIndexID.  Does that matter?

Show us your Form (Design View AND Form View).

Then that is the problem. Access has no idea what that field is.

Well, the thing is I'm following Richard in Developer 39 step by step and his works fiine. It also works fine in my production db., but that uses the original files, not my files. I've got to leave this for now for the rest of the morning. I'll get back as soon as I can, and thank you very much for the help.