update table data before clicking record navigation button

[anj]

Dear All
Thanks in advance! I got into a problem. I want to update
few data from "FORM A" to related TABLE A's control source
but not all data before I hit the next record selector
button on the record selector navigation button placed
automatically by Access on every form. I want to do this
because a "QUERY A" is based on "TABLE A" and I want to
display partial data with a "FORM B"(QBF TYPE FORM) based
on a "Query A" which get its required data from the "TABLE
A" which must show partial data before I click next record
navigation button which offcourse update all data that I
enter on form fields. How can I do this by writing code
that can be triggered by some command buttons. I would
appreciate if anyone can help me to find the code on the
form for navigation button which update all the data
entered on the form to the related table records.
Hope I have explained my problem clearly well.
Thanks !

 

[John Vinson]

How can I do this by writing code
that can be triggered by some command buttons. I would
appreciate if anyone can help me to find the code on the
form for navigation button which update all the data
entered on the form to the related table records.

Two ways, neither of which is easy to find in the Help:

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty Then Me.Dirty = False


John W. Vinson[MVP]