Data lost in one field - #deleted

[Mary]

I have a button on a main form that opens a second form based on the ID
field. The second form displays 5 fields for the same record displayed on the
main form. All of the fields on the main and second form are from the same
table. A few times now we've had a problem where a user will fill in the 5
fields, and the next time they go in, one of the fields shows #Deleted. No
one else was in the database, so I'm not sure why this is happening. It
works most of the time, but this situation has come up a few times and I need
to find out why.

Any suggestions based on this, or is more specific info needed?

Thanks!
Mary

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 06:38:01 -0700, Mary

Speculating I would think the field in question may be a memo field
and got corrupted. Compact your database.

-Tom.
Microsoft Access MVP