Auto Populating Fields in Form
I am trying to auto populate fields in a form once I type in a unique text in my first field. I have an unbound form with a datasheet view subform for entering new invoices. I have a separate table that has cost IDs with their associated description, cost months, expense type, etc. When I enter a new invoice in the subform, I want to enter its cost ID and have the form auto populate the remaining information like cost month, expense type, description, etc and save it in that linked table. Below are the exact tables and forms I have. Any help is much appreciated. Thanks.
Cost ID Table: FINMDW-CTC Assignments
New Invoice Table: FINMDW-Workspace
Main Form: FINMDW-main
Subform linked to New Inv Table: FINMDW_S_main