How do I stop Access from prompting me every time I want to append a record? I know there has to be an easy way to do this.

Hi,
execute your action queries with:

CurrentDb.Execute "YourQueryNameOrSql", dbFailOnError

HTH
Good luck

Thanks, I always wondered why people advise not to use DoCmd RunSQL.

It would require you to adjust the setwarnings property which means that even if the query errors out for some reason you will not see that. The .execute method surpresses the warnings as well...but still errors out when something goes wrong. Furthermore, it can run faster and prevent bloat on large recordsets.
HTH
Good luck