Help needed with data corruption on form

[MattCollins]

Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.

These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"

This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?

Thanks in advance
Matt Collins

 

[MattCollins]

Ok still needing some help on this, it seems to only happen or certainly happen more frequently when users copy and paste records from one recordset into another.....

Any ideas???

 

[MattCollins]

Been a while now but still getting this everynow and then.

The only way to get rid of the #deleted is to compact and repair and then go into the tables to delete the record.

Anyone else experienced this, have any ideas?

 

[MaliciousMike]

I had this problem and i fixed it but i don't know how i did it.

i THINK that it's got something to do with the "Enter Key Behavior" being bugged or something.