I have an Access 2007 FE database that links to a SQL server 2005 with ODBC linked tables.For most of the time the database works fine but every so often things go screwy in one form. The form uses a filtered record set in a continuous form view and allows the user to add and edit the records. This will be working fine for days and then suddenly when someone is in the process of entering a new record and at the moment the record is saved the details of that record change. Instead of the new record being displayed a previous and apparently random record is displayed. The displayed record won't even be in the selected filter set and the newly created record will not appear in the displayed records until the record set is refreshed. This behaviour then occurs all the time. The only way I can stop this behaviour is to cut all the records out of the table and then past them back in. I have tried rebuilding the indexes but that changes nothing. Does anybody have any ideas of what is causing it or how to stop it. Thank you for any response. Adam
