Dim rst As DAO.Recordset
In the Form_Load Sub I set it:
Set rst = CurrentDb.OpenRecordset("tblALS_Add", dbOpenDynaset)
This is referencing a different table from the one in current use by the form (I'm doing on-the-fly data entry verification). tblALS_Verify is the current table being used by the form, tblALS_Add is the outside one it is checking against).
After any old error message, this bit causes the problem:
rst.FindFirst strCriteria
It can't, apparently, find any reference to rst anymore. So I assume when a runtime error occurs, those references get dropped. Is there a different way of declaring these or Setting them so this won't occur?
[Edit] Yes, I know DAO is old. It's partially legacy code.