Copying data from one table to new records in another table

[tintindeluxe]

Hi,


I'm looking to copy records from one table into another using a command button.

I have a form that displays data from a table called "Training Records". The table has fields named "StaffID", "Training Session" and "Attended", which is a Yes/No field.

I'm looking to create a command button that would open up a new form showing a table named "Non-Attendance" and copy the "Staff ID" into a new record for each of the Training Records that were not checked as "Attended" for the training session shown in the previous form.

Sorry if my question was a bit long winded. I'm very new to access and still learning so I may need things explained in layman’s’ terms please!!

Cheers
Kylie

[khalid]

Welcome to the forum,

You can copy the unchecked/attened records to table "Non-Attandence" by putting the VBA Code on Click Event of the command button:

 
Docmd.RunSQL "INSERT INTO [Non-Attandence] SELECT FROM [Training Records] WHERE [Training Records].[Attended] = False"

HTH.