View Full Version : to save a record to another database from a form.


sowmya
03-17-2010, 10:45 PM
I am completely a newbie to access database.
I have created a form and populated data from table 1. In this form I have created a button and on the button click the data from this form will have to be saved into another table say table 2.
Pls help me on how this can be achieved.
If this is not the right forum for posting this msg, pls guide me on as to where i can post this msg.

Thank You.

Trevor G
03-19-2010, 05:11 AM
What yuo will need to do is create a query that looks at your record in the form and then use an append query to append a copy of the record to the second table.

Trevor