OK, so maybe I am making this harder than I should, but I want to save all the information from one record from a linked table by selecting an ID to a local table.
Example would be an Associates linked table with AssociateID, First, Last, Group, JobType
A combo box to select the AssociateID by First and Last name where the form is based on LocAssociate table.
Upon changing the combo box, all the associate data would be entered into the Local table LocAssociate.

The Combo box is fine, and the row source to select the associateID by the Name is fine. But how can I save all the data for the correct AssociateID into the LocAssociate table?

Thanks in Advance
Randy