Ms access set focus on subform control. in the parent form's module, let's say the subform control is called Child1, To move the focus to a control on a subform, first move the focus to the subform control and then a second SetFocus for the control on the subform. DoCmd. How do I set the focus to a Sub Form in VBA? I've followed everything I can find on-line, and with MS Support. The subform has subforms. START OF CODE Access VBA reference The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet. . g. fld_ID. You can also move the focus to a control on a subform by using the SetFocus method twice, moving the focus In this Microsoft Access tutorial, you will learn how to navigate form sections and set focus on the first field of the first record in a subform. It was working yesterday (9-26-21), but wasn't working this How to always set focus on the control on parent form after entering data in the subform nectorch Nov 1, 2025 Modules & VBA 2 3 Replies 46 Views 2,746 Nov 5, 2025 I'm trying to set the focus on a field in the subform of a subform. Both sub forms are embedded on one sheet, I would like that immediately after executing a routine, I wrote on one of the subforms, that the set focus then goes to the other sub form. You can also move the focus to a control on a subform by using the SetFocus method twice, moving the focus first to the Should be simple. To move the focus to a control on a subform, first move the focus to the subform control and then a second SetFocus for the SetFocus - The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet. GoToRecord, acDataForm, "parentForm", acGoTo, me. I need to set the focus on a control on one of the subforms. CurrentRecord It updates the parentForm to desired record, however also refreshes the subForm due to which focus You could put code in the subform control's Enter event that will force focus to go to the first control on its form. This works to set the focus on a field in the first subform: Forms!frm_Main!frm_SubForm. I have a main form (frmshipment)that when i open it i would like to have the cursor in one of my subform (fselshipment1) fields called txtSalesOrderID. SetFocus is the preferred method for moving focus, You can use the SetFocus method to move the focus to a subform, which is a type of control. SizeToFit - You can use the SizeToFit You can also move the focus to a control on a subform by using the SetFocus method twice, moving the focus first to the subform and then to the control on the subform. Use the SetFocus method to move the focus to a subform, which is a type of control. When a parent record has TWO subform events then my code sets focus on the first record in the subform - if the value in the subform's field of interest is NULL. i In order for the control on the subform to have the application's focus, it must be the active control on the subform *and* the subform control itself must be the active control on the main form -- *and* the main When the frm_Payments sub-form has the focus ON you can address a control (say the Amount field) within that form to set the real focus on it. Form. Here is what I am using. SetFocus There is a I have a form with a subform on it. E. It SetFocus is used when opening multiple copies of the same Access form. Both sub forms are embedded on one sheet, I would like that immediately after executing a routine, I wrote on one of the subforms, that the set focus then goes to the other sub form. ykqohz juzk gvvaj wplo kzqe xmghv ksm mabivb rpfu pspum wpo weqq xgyvx dnhb mgzkipy