CommitOnNavigation error message

[N2Life]

From Windows XP Professional, I opened an Access 2000 database today that opened yesterday with no problem. Today I get this message:

Run-time error '2455':
You entered an expression that has an invalid reference to the property CommitOnNavigation

I have never heard of CommitOnNavigation. I click on Debug and find the following line highlighted. The txtLatestOutput_record is a textbox on the main form.

txtLatestOutput_record = DMax("DateTime", "tblProd")

from this subroutine:
Private Sub RefreshLatestDates()
txtLatestDUL_OT_record = DMax("WorkDate", "tblTimes")
txtLatestOutput_record = DMax("DateTime", "tblProd")
End Sub

I copied the right side of this into the Immediate Window and found that it works properly:
? DMax("DateTime", "tblProd")
10/21/2006 10:36:12 PM

Has anybody else experienced this? How did you handle it? I suspect I shall have to copy all entities (forms, queries, etc.) into a new clean database to make this go away, but thought I'd ask the group before I do that.

 

[Remou]

Have you looked at your references to see if any are missing?

 

[N2Life]

Thank you Remou. References were in order. Not surprising since the first DMax line worked perfectly.

I have now copied everything over into a clean new database. This removed the problem. I highly recommend this approach to anyone suddenly experiencing totally weird behavior from a database. The 'repair' part of 'compact and repair' has never once for me done any repair.