DB crashing on certain records

[Rob.Mills]

I've created a small application for about 5 users.

This morning we've been finding something strange going on. All the records in the table have a field that contains a user's windows id. So when they open the frontend it will only show the records assigned to them. So there should be no way that two people would be editing the same record at same time.

Now on my form I have a combobox where the user can make selections. In the After Update event of this combobox I tell it to mark today's date in a hidden textbox. The problem is occuring here. We've only found two records out of 2,000 that when the user makes a selection everything locks up. They can't do anything. But every other record works just fine.

Any ideas what might cause this??

 

[Rob.Mills]

I've found the problem to exist on the table level. When I try to change the number in the field and then move to another record it gives me the error:

'The Search Key was not found in any record.'

First time I've ever seen that one before.