I have some very specific questions about the attached database:
1. in the Frm_workcentre_only...the user can pick a workcentre and then the workorder numbers will populate each of the 5 dropdown combo boxes. However, I notice that the selections in the combo boxes (work order 1...5) are not changing when I move onto the next order..how can I fix that so that the choices given in the dropdown reflect the work centre number chosen e.g. if I choose 641040044 in the work centre number I get the correct values in the dropdowns BUT if I go to another workcentre, I still have the 641040044 values in my dropdown.
2. How can I append the values that are selected in this form into a table. I have created an append query called QryAppend_to_Heat_Treat and then applied this to the button on the frm_workcentre_only (Update Records) but it's not appending any records to the Heat Treat table. I've referenced the form controls in this query.