copying from one table to another in ms access 2007
If I have a database table with 20 records and want to copy a few records that have been checked off to second existing table (using a check field in the first table) how is this easily accomplished. I assume you have to do it in VBA as I am using access 2007.
record 2 (checked)
record 5 (checked)
(contains 50 records)
simply take record 2 and 5 and copy them into TABLE 2. Then uncheck the two records.
I am not sure if I have to reopen the tables in VBA? I have a check field in TABLE 1