Can't update a bound form

[GerryGoldberg]

I am creating an Access 97 form (running under Windows XP) that contains fields bound to an underlying table. When I modify any field on the form, I get this WRITE CONFLICT error:

This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the changes the other user entered, and then paste your changes back in if you decide to make the changes.

I know that there is something the error is not telling me, but I can't figure out what it is. Can anyone help me?

Thanks

 

[JeremyNYC]

Heh. Just answered this same thing in another thread. This usually comes about when you've got code in a bound form that changes data on a record where changes have already been made in bound controls on that form. The easiest way to deal with it is to save the record at the start of your code:
call docmd.runcommand(accmdSaveRecord)
(I'm not 100% sure I'm remembering the command constant correctly, but the intellisense should tell you).

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[romanzero]

Yeah I'm the other one struggling with the same problem.

Where do I put the DoCmd.RunCmdSaveRecord?

Is is a conflict on the master form or the subform?

I've put the command on both (Before Load) and still get the same message...

 

[eggy168]

It happens to me, too. My solution is you can check the base table, and may be you find duplicate records.

 

[JeremyNYC]

Put that line at the start of the code that creates the error. ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.