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

bengelhartAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
U could just try, from the subform

Me.Parent.Form.Dirty = False
0
 
rockiroadsCommented:
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
0
 
bengelhartAuthor Commented:
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.
0
 
bengelhartAuthor Commented:
That worked!!  Thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.