I'm using a database which currently gets updated nightly by our overnight staff if they don't forget. Is there a way to have this run automatically? When the form opens there is an update button which needs to be clicked in order for a certain class module to run. This runs approximately 25 different append queries. The person who created the database is no longer with the company and it has been passed on to myself to learn as much as possible about it.