You can create an append query, and have the command button run the query.
1. Create an Append query, and call it something like qryAppend_tbl_destination.
The query would look something like:
INSERT INTO tbl_destination ( Field1, Field2)
SELECT [Forms]![FormName]![txtFie
Where FormName is the name of your form, and txtField1 and txtField2 are the field names on your form that hold the values that need to be added ot the tbl_destination table.
2. Create a command button, and add code to run the query:
DoCmd.OpenQuery "qryAppend_tbl_destination
Main Topics
Browse All Topics
by: perkcPosted on 2003-06-23 at 12:30:34ID: 8783994
Are both table designs the same? If so it would look something like:
If all records to move have a flag assigned:
docmd.runsql("INSERT INTO tbl_destination " _
& "SELECT tbl_source.* " _
& "FROM tbl_source " _
& "Where tbl_source.moveflag=true;"
Otherwise how are you determining if the record should be added to the tbl_destination table? Are you adding all records from the tbl_source table into the tbl_destination table?
If so then use the following:
docmd.runsql("INSERT INTO tbl_destination " _
& "SELECT tbl_source.* " _
& "FROM tbl_source;")
Let me know if you need anything else.
perkc