I am trying to right some VB code that on the face of it is basic however I have spent over a day trying to get it to work but unsuccessfully.
The overall objective is: I have an applicant table containing details of applicants for a job vacancy. At some point an applicant is offered the post so on the applicant form I have a “Convert To Employee” button that runs a number of append queries, taking the applicants title, name, contact numbers, (and applicant ID) etc. and creates a new employee record in the employee table (that’s all working fine). I then want the code to open the employee form (that’s a sub form) on the newly created employee record so that any additional data can be added.
The applicant form has a number of sub forms with contact numbers, references etc. but the main form is based on a table “tbl_app_details” and the key field is “App_ID”
The employee form is a sub form inside “frm_Index_Employee_HR” subform name: “frm_Emp_Details_Current” based on a table “tbl_Emp_Details” The table includes an Emp_ID & App_ID
So the it of code I am struggling with is after the append queries have run, adding the app_ID and name details to the “tbl_Emp_Details” is to then open the “frm_Index_Employee_HR” form and go to the subforms "frm_Emp_Details_Current” record that is equal to the App_ID in the “tbl_Emp_Details” table.
Any help appreciated