Please Help! I messed up our DB here and need to fix it before COB today since I take off on vacation tomorrow.. Arrrgghhh

I added 12 records this afternoon to my DB. One record will not update as it should. I.E. I change the work status on it and I get errors. Mostly this is done within a form; but after the errors I went directly to the table to change the information I needed to and I get errors I don't know what to do with.
When I try to change any field in the table for this one record only I get a "The Search Key was not found in any record"

This is the first time seeing this type of error. Not sure what it means. I can't even select this record and delete it. Any ideas?

Please?

:)

Have you tried a Compact and Repair? It sounds like an index is corrupt.

Update..
It appears that there is just one field that if I change it errors. Just happens to be the field that changes the status of a part from in the shop to a turn-in. The table uses numbers (1-4) for this field; the form uses common names (I.E. TurnIn, InWork, WaitParts, etc).
So; I woud think it has to do something with the way these fields are linked; but the link is there for all the other 1000+ records; just not this one?? That's what isn't making sense.. How could that happen?

Or; am I off-base all together?

Just tried a compact/repair... didn't help :(

Does your database use Lookup Control at the table level? The error:

"The Search Key was not found in any record"

sounds like what I get when I enter a value outside a list when entering into a form. Other than that I only wish I could help. Time off from work is always a good thing.

Lookup at the table level? No; I don't believe so; that's just at the form level I think...
Just checked design view on this table; there's no lookup for this field. This is done through linked fields between tables (I believe).

Sorry,

I gave it a shot. Perhaps someone knows if the Linked tables are related to your problems.

FIXED IT! Whew.
Still don't know why i got the error or what happened. But for future reference here's what I did...

i copied the the problem table and pasted it into a backup copy of the db. I then went to the offending line and made changes. No errors! So, I copied the table from this backup db and pasted it back into the original file. Everything works as it should again!

Wierd; wish i knew why this happened or what was causing it; but it's working again and I'm not going to complain! :P

Enjoy your vacation. ;)

Off I go; On the road again; :) WHEW!

Good luck during your time off