<div>
You just need to execute an INSERT INTO query:<br />
<br />
&nbsp; &nbsp; INSERT INTO SecondTable (FirstField, SecondField, ThirdField)<br />
&nbsp; &nbsp; SELECT FirstField, SecondField, ThirdField<br />
&nbsp; &nbsp; FROM FirstTable
</div>


You just need to execute an INSERT INTO query:

    INSERT INTO SecondTable (FirstField, SecondField, ThirdField)
    SELECT FirstField, SecondField, ThirdField
    FROM FirstTable

<div>
<div class="content wysiwyg-content">
I have a form in access 2007 that pulls informtion from a query into my form. &nbsp;I make updats to that information. &nbsp;Afater updating that information I want it to be transfered into a different table. &nbsp;How do I do that? &nbsp;
</div>
</div>


I have a form in access 2007 that pulls informtion from a query into my form.  I make updats to that information.  Afater updating that information I want it to be transfered into a different table.  How do I do that?  

Transfer Information

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.