Transfer Information

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?  
Terrell37iAsked:
Who is Participating?
 
JezWaltersCommented:
Or from VBA (you'll need to add a Reference to the latest Microsoft DAO Object Library too):
CurrentDb.Execute "INSERT INTO SecondTable (FirstField, SecondField, ThirdField) " & _
                  "SELECT FirstField, SecondField, ThirdField " & _
                  "FROM FirstTable ", _
                  dbFailOnError

Open in new window

0
 
JezWaltersCommented:
You just need to execute an INSERT INTO query:

    INSERT INTO SecondTable (FirstField, SecondField, ThirdField)
    SELECT FirstField, SecondField, ThirdField
    FROM FirstTable
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.