Records getting deleted

[Jaspal]

This has got me stumped.

We have a massive db and on one of the screens the users can scroll through the records and view information they can also add new records. When the users enter the new record and go back to it it has been successfully stored in the relevant table even on exitin the form via the exit button (DoCmd.Close). However from time to time when the user enters the new record and closes the for via the close form button the new entry is not stored in the table and seems to have been deleted or not appended to the table.

We have no idea why this is happening as it doesnt happen all the time just from time to time.

Can anyone help please or has anyone come across this before !

Thanks for any help !

 

[Jings00]

I have seen this for both record edits and record appending.

Try putting the save record command on your close button before the close command and see if that helps.

Example : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70