Changing field leads to "the search key was not found in any recor

[markmarko]

On our Install Order form, if user changes value of combo box OrderStatus
(with row source of a list table), when the user then tries to go to another
record, it displays "The search key was not found in any record."

It only happens in certain records, and it happens fairly conistently in
those records. I have searched for info on that error message, and cannot
figure out what the error even means.

I suspect this error is related to my "Crazy Problem" post here
http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1

Any advice?

 

[markmarko]

Ok, so I just discovered that it happens even if the change is made directly
in the underlying table as well.

 

[markmarko]

Ok, now it happens in a different field. A date field. If the date value is
changed, even in the table itself, when user tries to leave the record, the
error "The Search key was not found in any record" appears.

Any advice is greatly appreciated!

 

[John W. Vinson]

Ok, now it happens in a different field. A date field. If the date value is
changed, even in the table itself, when user tries to leave the record, the
error "The Search key was not found in any record" appears.

Any advice is greatly appreciated!

Your database (probably the system tables or indexes) is seriously corrupted.

See http://www.granite.ab.ca/access/corruptmdbs.htm for a description and
possible cures.