Write Conflict message

[Zaeed]

Hi, I keep getting a write conflict message when i try and modify a record..

can someone explain to me why this occurs

 

[boblarson]

How are you trying to modify the record? Do you have one of these things perhaps:

1. Subform and Main form based on same table.

2. Bound form but using SQL to do the update.

 

[Zaeed]

Bound form with a SQL update.

the sql update gets called in the BeforeUpdate

am i doing it wrong?

 

[boblarson]

Don't use SQL. The form will take care of the update. Validate in the form's Before Update event and then let it do its thing if it passes or use a Cancel = True if it fails. Or else you will have to make sure that the form has saved before running the SQL.