write conflict - needs internediate "commit"

[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

 

[Allen Browne]

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.

 

[Guest]

Works like a charm!!

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.