Run a query on load

[amfroehlich]

I have a append Query that I want to run everytime the access database is opened.

What would the code be for this and where can i put it?

Thanks

 

[jmersing]

Put it on the form you load when the db opens on the "On Open" event

you can us code like this

docmd.openquery "yourappendqueryname"

You may want to set the warnings off or you will be prompted that you are going to append records to a table to do that:

DoCmd.SetWarnings False
docmd.openquery "yourappendqueryname"
docmd.setwarnings true