Data Disappears

[rma]

I have a database that has been running fine for over 5 years. Recently, odd
behavior started - like data being entered into a form and then disappearing.
One thing I have determined is that if one field (MRN) is completed then all
the other data entered on the form disappears, but if I don't enter data into
the MRN field, everything is fine. This does not happen everytime though.

This also causes the autonumber that is generated to be used and then
deleted along with the entire record, however there is evidence that the
information was entered from my audit trail.

Is it possible to have one variable corrupt? If so, how to I fix it???

 

[Allen Browne]

This is odd.

There is a case where Access silently discards your entry without any
notification. See:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

However, that does not describe your case, because you say the problem
occurs when MRN is completed (not when it's left blank.)

The missing autonumber does not demonstrate the record was ever saved:
Access assigns a value when you start entering a new record, and the number
is not reused if you abort the entry.

If MRN is a foreign key, it may be worth checking if it is involved in a
relationship with cascading deletes. That could explain the disappearing
data.

You've proabably already tried a compact/repair, in case there is a
corruption/bad index here.

It might also be worth checking to see if there are any macros or event
procedures in the properties of the controls or the form where you enter
this data. Lots of things could block the entry, e.g.:
Cancel = True
DoCmd.CancelEvent
Me.Undo
or references to Delete or OldValue.

Also check for any tables with a name including "Compact Error", which could
give further clues.

HTH