The search key was not found in any record!

[Aerin]

Help!
I am completely stock on it

I enter the data and save the record and it works fine but when I go back to the form and try to change the field (key field) - I receive this type of message ((
I was try to create an update query and change this field there...Same message, even if the form is closed during the query processing.

Big big Thanks for any ideas

 

[TheAceMan1]

How are ya Aerin . . . . .

Your post is pretty vague. At best, we can only guess whats going on.

[blue]but when I go back to the form and try to change the field [purple](key field)[/purple][/blue]

Are you talking the [purple]PrimaryKey[/purple] here . . . . what?
If so, is it [purple]autonumber[/purple]?

[blue]I receive this type of message[/blue]

Post the message!

See Ya! . . . . . .

 

[Aerin]

Yes, it is autonumber and the message was the same " The search key was not found in any record

 

[TheAceMan1]

Aerin . . . . .

[blue]You can't change an autonuber field![/blue]

See Ya! . . . . . .

 

[Aerin]

The AceMan1,

))))))))))))) I know, I wasn't going to change it.

I didn't understand your question properly. I have the table with patients and their id number is autonumber. Then I have Claims table and there SURE the id field is numeric This Claims table has a key with two fields: ClaimID and PatientID. I can't change the PatientID in the Claim table....couldn't. Looks like I made it working...

 

[TheAceMan1]

[blue]Looks like I made it working...[/blue]

Really . . . . and [blue]what did you do?[/blue]

See Ya! . . . . . .

 

[Aerin]

Strange, but nothing. I tested the code on one record all the time and when I changed another record, it was working and working with all records accept one record. I deleted it and now everything works. I am just afraid that something was really blocking the record and could happens again. So far, no probs was found.

Thank you for support

 

[TheAceMan1]

Aerin . . . . .

Glad ya got it fixed . . .

You Take Care . . . . Ya Hear!

See Ya! . . . . . .