http://blogs.office.com/b/microsoft-access/archive/2011/05/02/power-tip-automate-an-update-query.aspxPower Tipster Justin Farrell has posted a new tip on his blog, showing how to create and execute an update query by using a form and a small amount of Visual Basic for Applications (VBA) code. After following his tip, you'll be able to update a largeen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-access/archive/2011/05/02/power-tip-automate-an-update-query.aspx#25813Mon, 16 May 2011 06:03:38 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25813Shasur<p>Nice post Chris.</p> <p>How about having a Rollback/Undo button the changes. It will throw open the possibilities of enhancing the form</p> <p>Cheers</p> <p>Shasur</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=25813" width="1" height="1">http://blogs.office.com/b/microsoft-access/archive/2011/05/02/power-tip-automate-an-update-query.aspx#25654Thu, 05 May 2011 15:24:09 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25654Chris Downs<p>Thanks for the comment and the additional info, Luke!</p> <p>--Chris</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=25654" width="1" height="1">http://blogs.office.com/b/microsoft-access/archive/2011/05/02/power-tip-automate-an-update-query.aspx#25650Thu, 05 May 2011 15:15:04 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25650Luke Chung<p>Here&#39;s a related paper I wrote on &nbsp;Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access. Useful when you get the error message: This Recordset is not updateable.</p> <p><a rel="nofollow" target="_new" href="http://www.fmsinc.com/MicrosoftAccess/query/non-updateable/index.html">www.fmsinc.com/.../index.html</a></p> <p>Hope this helps.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=25650" width="1" height="1">