The data has been changed error message

[TracySHC]

I noticed that the "The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record" message has been dealt with in this forum. I am updating a file when a command button on Form A is clicked, and then displaying Form B. When a field on Form B is changed, I am receiving the above message. I am updating using SQL statements rather than a recordset. What should I do so that this message doesn't occur?
Thank you in advance for your advice and help,
TracySHC

[ADezii]

Try changing your Locking Strategy, perhaps:

1. Open Databases using record-level locking.
2. Lock Edited Record (Pessimistic Locking).
3. Both of thes Options can be found under:
   

   Tools ==> Options ==> Advanced