Record Missing

[KeithB14]

I have a weird situation and I was wondering if anyone has had an issue with this. I have a record missing from a table. Normal Users are not allowed to delete records from the Form view. There is a blank record where the record should be. The auto number counts from 37, 38, 40. Record 39 is missing and there are blanks where it should be. The autonumber field is my Primary Key and it is blank just like the rest of the fields in the record. I know that the record existed at one time because one of the DB users has a report referencing that record. Any Ideas?

Thanks for the help,

Keith

 

[rsmonkey]

Well i would say that its almost deffinately that the record has been deleted somehow along the way... access is not the most secure of databases. Access doesnt just forget records unless you didnt save it