Link to home
Start Free TrialLog in
Avatar of bengelhart
bengelhart

asked on

Write Conflict Due to Code Updating

I have some code (ADO) that runs from a child form and updates some fields on a parent form.  I always get a write conflict message when this runs.  I tried putting a save function in for the parent form from the child form and it isn't working (look at line of code below).  Any ideas on how to figure this out?

Forms!frmPriceQuote.Form.Application.DoCmd.RunCommand acCmdSaveRecord

ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the forms are bounded and you have made changes via form, then u try to make changes via code, u may get the error. I don't know what your steps are.
But setting Dirty to False forces a save
Avatar of bengelhart
bengelhart

ASKER

That would stop the write conflict?  I figured  I would need to run some kind of save function for the parent form right before I run my ADO code in the subform.
That worked!!  Thanks!!