Hello Everyone I hope everyone is staying warm. Can someone help me again on this brain teaser and I know it is something obvious I am missing. I have created a Horizontal Navigation form. That form is named for the sake of this discussion AjaxCo. I have two sub-forms within this navigation form are (Employees) and other named (Clients).
What I would like to do is as I tab through first tab form (Employees) when I lose focus on field named Spouse. I want to be able to automatically jump to next sub-form within this navigation form which is entitled (Clients) and regain tab focus on first field in (Clients) which is entitled FirstName.
I have placed the following code in First SubForm (Employees) field Spouse lost focus event
Private Sub Spouse_LostFocus()
Me. AjaxCo!Clients.Form! FirstName.SetFocus
However, it is not triggering the desired response and getting errors. Does anyone have any ideas? I hope I explained it well. Once again like always Thanks everyone for their help and expertise I really appreciate it.