How can I send the focus from a Textbox on the Main Form to a Textbox on the Active Tab Sheet's subform?
I have a Form called frmEmployee.
On the top of frmEmployee, I have 3 Textboxes (txtName, txtID, txtClock).
Below those Textboxes, I have a Tab Control (tabctlEmp) with 7 Sheets (tabPersonal, tabAttendance, tabInsurance...etc.).
Each Tab Sheet contains one subform (tabPersonal has [PER subform], ...etc) looking at different tables.
On each of those subforms, there are Textboxes ([PER subform] has txtAddress,... etc).
I want to set the Tab Order to leave the txtClock Textbox on frmEmployee and go to the first Textbox on the Active Tab Sheet's subform.
I put code in the txtClock Textbox's "OnExit" event to set the focus to the Tab Control, but it always goes to the first Tab Sheet. I want to have the focus go to the first Textbox on the Currently Visible Tab Sheet, but I don't know how to identify the Tab Control's "Active TabSheet" Property (if there is something like that).