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