Write conflict

[Guest]

I have a database to which I just added a timestamp field. The update query
I'm using uses an ID number from the form used to edit data as criteria and
is set to update the timestamp field to Date() when the user clicks a command
button on the form. It works fine except for a write conflict the user gets
after they have clicked the command button and then try to move to another
record. Any ideas as to what's going on?

Any help is appreciated!

 

[Guest]

hi,

Sounds like the table column which stores the record IDs generated by the
form is trying to enter duplicates. Just make sure the table can allow
duplicates if that's what you want, or edit the unique identifier criteria to
allow for a little more complexity.

Hope this helps,
geebee