I am trying to automate an append query after watching the Access 2013 Expert 15 video. My goal is to be within a form that is based on a different query, push a button, and have some of the data on my form append to my "Updated" table.  I created the button based on what I learned in the video, but my records are not being added. I have confirmed the accuracy of my append query--in fact, it runs just fine if I manually open up the query.  But the macro (SetWarning-No, OpenQuery, SetWarnings-Yes, Requery) isn't executing the append--just requerying the form.  My original form is based on a query within a query--if that helps.  I attempted a completely different method by adding some VBA but I kept getting the "Run-time error '3061'. Too few parameters." code.  I'm stuck and have tried everything I can think of....any help would be most appreciated.  Thanks!

---

Reply from Alex Hedley:

If you remove warning in your macro and run it what message shows?