Populating Data from one Table to another

[DavidAC]

Help i must have my thick head on today. I have a table (staff) which contains a list of staff and their vehicle registrations. This table then needs to be used to populate another table which will contain records of accidents etc. How do i copy the necessary data choosen on the form from the staff table to the data table.

 

[garyd1234]

You could use DoCmd.CopyObject, "Employees Copy", acTable, "Employees"
if you want to copy all the data over. If you want to copy select data lines you probably need to write some code to take the item selected on your form and do a FindFirst (like a recordset) then do an insert SQL statement to put it in the other data table.