Data macro to update date from one table to another in access (1 Viewer)

[saledo2000]

Hello,
Is it possible to create Named Data Macro to update date from one table to another on open database. I will put that Named Data Macro to Autoexec macro to execute update. Can you please help with this because I do not have big experience in access.
Thank you.

 

[theDBguy]

Hi. If you want the macro to execute when the db opens, then you don't even need to use a data macro. A UI macro should be enough.

 

[Ranman256]

make an append query,
put it in a macro,
have it run at a button click on a form by a user.