I have a main form [Emp_New] and a subform [Class_Catalog subform] my save button is on the main form. When I click save it saves the values in the controls on the main form to the Emp table it is based on. Problem is the subform. It is based on the value in a the txtJobtitle control on the main form which is great. From that value it pulls Class_ID (a text box) from a table named Class_Catalog. It also has a field that simply copies the Emp_ID field (a text box) from the main form. I need the subform to save the Class_ID and Emp_ID into the Classes_taken table when the main form save button is clicked.
Here are the control sources for the controls in the subform:
Class_ID: [Class_ID] (this is from the class catalog table)
Emp_ID: =[Forms]![Emp_New]![txtEmp_ID] (this is from the main form )
I tried adding a save button to the subform but I get the "command or action 'RecordsGotoNew' isn't available now" error.
Here are the control sources for the controls in the subform:
Class_ID: [Class_ID] (this is from the class catalog table)
Emp_ID: =[Forms]![Emp_New]![txtEmp_ID] (this is from the main form )
I tried adding a save button to the subform but I get the "command or action 'RecordsGotoNew' isn't available now" error.