Updating records vs. adding records

[Russ1005]

I have a form and I want to update an existing record if onc exists or add a new record if the primary key doesn't exist. Currently when I save the form, it tries to add a new record and gives me a primary constraint violation on the primary key instead of updating the existing record. I have the table set up as indexed Yes no duplicates.

How can I update a new record instead of add a new record?

Thanks,
-Russ

 

[Remou]

Hi
I think perhaps a little more information is needed, for example: has this form got a record source?

 

[Russ1005]

The record source is:

SELECT [customer_claims_check_request].* FROM [customer_claims_check_request]

This is very weird. I just updated the record successfully without getting the contraint violation error. The odd thing is, I didn't change anything.

 

[Remou]

Magic! :-D