is it possible to have a command button or event to copy records into another table on a form.

for example i have a qry w/ employee names and another table used for tracking attendance. i need employee names to be copied into the attendance table.....

can anyone give me an example for how to do this.

thanks to all in advance.

You don't need to store the names in the attendance table. You can include a join to the employee table when you build the query for a report or form. That will allow you to show the employee name at the same time as the attendance data.