Data disappears

[rma]

I have a database that has been running fine for over 5 years and no changes
have been made recently. However, data seems to be disappearing immediately
after entry, when the person closes the form. I have noticed that if
information is entered into one particular field (MRN) then the other data
entered into the form disappears, and sometimes the entire record is gone,
along with the autonumber generated. There is evidence that the data was
entered in my audit trail. This doesn't happen every time.

Just to clarify, I do not have it set to Date Entry=true and the data is
gone from the table, not just visible on the form.

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

 

[Jerry Whittle]

Is the form based on only one table? If there are multiple tables you may
have a problem with an inner join and not having a matching record in both
tables.

Can you manually add a record directly to the table? If not them might be a
corruption problem or maybe something preventing the change like a permission
issue. If you suspect corruption, make a copy of the database first then do a
Compact and Repair.

If you can enter a record at table-level, then there may be something wrong
with the form. Is there any fancy code called by the form? Is the form bound
to the table or is it an unbound form?

 

[rma]

The form is based on one table, bound to that table with no fancy code aside
from an audit trail that is on all forms.

I can manually add to the table and the odd thing is that it doesn't always
happen. Sometimes it will refuse to allow the entry and then later allow it.

I created a new database and imported all tables, forms, queries and macros
and did a compact/repair. That didn't help so I created a new MRN variable
and imported the existing data and deleted the old variable with the hopes it
may help.

Thanks for your help!