Macro for append query

[dcollard23]

Hi, how do I go about creating a macro that will run an append query when the database is logged into or when a form is loaded? (If there is a better more efficient way to do this besides a macro please let me know i.e. SQL) Thanks for your assistance in advance.
Elaine

 

[exzant]

you can add this syntax at Form_Load()
DoCmd.RunMacro "YourMacro"

 

[dcollard23]

Thanks I will try it.

 

[georgedwilkinson]

Or you could skip the macro in between and just use (air code):

DoCmd.RunQuery "YourAppendQuery"