Set focus to a form after closing sub form
I have a popup modal form that incorporates a subform used to search records. Once a record is clicked on the subform, the subform filters a form called frm_LoanClosing. Then the code in the subform closes the main form that the subform resides in. At that point, I'm trying to set the focus back to a control on frm_LoanClosing. I have the following in the On Close event of the main form that holds the subform:
Forms!frm_LoanClosing.Cont
However, not only does the focus not land on the cmbApplicatonNumber control, it doesn't even land on the frm_LoanClosing form.
I have attached an example MDB with the forms.
Example.mdb
Forms!frm_LoanClosing.Cont
However, not only does the focus not land on the cmbApplicatonNumber control, it doesn't even land on the frm_LoanClosing form.
I have attached an example MDB with the forms.
Example.mdb
ASKER
That didn't work. Maybe I'm calling it from the wrong form or event?
You can't set focus to a form - it has to be to a control on the form (as cap suggests)
This may also help:
http://www.mvps.org/access/forms/frm0031.htm
This may also help:
http://www.mvps.org/access/forms/frm0031.htm
ASKER
I'm confused because I am able to change he value of the control with
Forms!frm_LoanClosing.Cont
But I can't set the focus to the control as well. I must be causing a conflict with another spot in my code.
Forms!frm_LoanClosing.Cont
But I can't set the focus to the control as well. I must be causing a conflict with another spot in my code.
Try changing the line of code to:
Form_frm_LoanClosing.cmbAp
Form_frm_LoanClosing.cmbAp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, that was the answer. My code disabled the control for other reasons before I tried to set the focus.
Forms!frm_LoanClosing.cmbA