Update records in the active form using macro or code

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

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
 
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
Click to expand...

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