Force Writing of the Buffer

[Chris Eberhart]

Is that a simple way to force an open form to write it's
buffer to the affected tables (update them) so that the
data are available?
I have done this by moving back a record and then forward
again, but this is a non-elegant solution.

 

[Dirk Goldgar]

Is that a simple way to force an open form to write it's
buffer to the affected tables (update them) so that the
data are available?
I have done this by moving back a record and then forward
again, but this is a non-elegant solution.

There are several ways. Manually, you can press Shift+Enter to save the
current record. In code you can execute the statement

RunCommand acCmdSaveRecord

or

Me.Dirty = False

to save the record.