i am using Access 2010 and i have 3 tables, studentinfo, testscores and attendance.

what i would like is for when i enter the student information into the studentinto table that it copies over lastname, firstname, dateenrolled, studentid and grade into the testscores table and lastname, firstname, dateenrolled into the attendance table.

i enter the information in using the datasheet view.

i have read to use the table tab, after the table is open however the options for after events are greyed out and i am not able to use them.

please advise how i would be able to accomplish this task

thank you