Update records in the active form using macro or code

[Guest]

Is it possible to write data back, from an active form, to the underlying
table, using a macro or piece of code? There is the option to select
'Refresh' option in the 'Records' menu or click on the long narrow button on
the far left of the screen (with the picture of a pencil on it) and these
both do the desired action. I was wondering if it is possible to automate
this action using a module or code
Thank You

 

[Gijs Beukenoot]

From Pete :

Is it possible to write data back, from an active form, to the underlying
table, using a macro or piece of code? There is the option to select
'Refresh' option in the 'Records' menu or click on the long narrow button on
the far left of the screen (with the picture of a pencil on it) and these
both do the desired action. I was wondering if it is possible to automate
this action using a module or code
Thank You

docmd.runcommand acsaverecord
Although I'm not 100% sure about the last parameter, please verify in
the help...