I've been expanding my Access 07 database with a couple of new tables, queries, forms and reports in a back-up of last save. Some of these new objects are copies of other tested, working concepts.
Yesterday I came across a run-time error:
'3709': Search key was not found in any record
in a form I made in 2009 and has been used 3 years. I know that this can be a sign of a corrupt file but spent some time anyway tediously checking data, libraries, table links; whatever suggestions I could google up.

Well, wouldn't you know it, the error does not occur in that form in my previous back up.

Where do I begin to escape the corruption?
Is it just that one form that is corrupt?
Do I delete the form and import the old one in (from the db that is not erroring)?

FYI: This is the code it errors at on the first CurrentDb.Execute stSQL, dbseechanges
Private Sub Form_AfterUpdate()

Dim stSQL As String

stSQL = "UPDATE ACCTTABLE21109 SET [ACCOUNT] = Replace([ACCOUNT],'.', '')"
CurrentDb.Execute stSQL, dbseechanges
stSQL = "UPDATE ACCTTABLE21109 SET [ACCOUNT] = Replace([ACCOUNT],',', '')"
CurrentDb.Execute stSQL, dbseechanges
stSQL = "UPDATE ACCTTABLE21109 SET [ACCOUNT] = Replace([ACCOUNT],'The ', '',1,1) WHERE Left([ACCOUNT],4) = 'The '"
CurrentDb.Execute stSQL, dbseechanges
stSQL = "UPDATE ACCTTABLE21109 SET [ACCOUNT] = Replace([ACCOUNT],'-', '')"
CurrentDb.Execute stSQL, dbseechanges



End Sub