write conflict - needs internediate "commit"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with most popular fileds from a table, and usually updates are
from here, but I have a more detailed form I sometime go to for more edits.
If I forget and update both places I get a write conflict error. What I need
is that if I press the "Go To Details" button, the changes I just made are
saved first, like when I close the form, and them I go to the "Details" form.
What command will make my changes permanent without closing the form??

Thanks,

Lisa
 
Try either of these:
If Me.Dirty Then Me.Dirty = False
RunCommand acCmdSaveRecord

The first one works even if the form does not have focus, but if you just
clicked a button it's a safe bet that the form has focus.
 
Works like a charm!!

Thanks,

Lisa

Allen Browne said:
Try either of these:
If Me.Dirty Then Me.Dirty = False
RunCommand acCmdSaveRecord

The first one works even if the form does not have focus, but if you just
clicked a button it's a safe bet that the form has focus.
 
Back
Top