I have a form that populates a field on a table. How can I get the field entry to populate a different table as well?
Form records employee name and populates tbl_employee name field. I would also like that same entry to be recorded on a tbl_employee_end. I think an Afterupdate will do it but I don't know how to call the tbl_employee_end from the form(it references tbl_employee) and populate it with the value in the name field.
VBA? Macro? Something simpler?
Any ideas?
Thanks
Form records employee name and populates tbl_employee name field. I would also like that same entry to be recorded on a tbl_employee_end. I think an Afterupdate will do it but I don't know how to call the tbl_employee_end from the form(it references tbl_employee) and populate it with the value in the name field.
VBA? Macro? Something simpler?
Any ideas?
Thanks