Automatically move to next subform, first field upon pressing tab on final field

[Shadows1989]

Hi,

Wondering if someone can help me:

Is there a way to move to subform_2 field1, from subform_1, field5 when Tab has been pressed on the keyboard?

I found this code online, which explained 3 possible ways: https://bytes.com/topic/access/answe...-automatically:

Private Sub PhoneNumber_LostFocus()
Me.Parent.SetFocus
Me.Parent!NextSubform.SetFocus
Me.Parent!NextSubform.Form!NextField.SetFocus
End Sub

Which I adjusted to my application, as I gather, I want to use the last possible way, but it doesn't seem to work. Is anyone able to help?

Private Sub field5_LostFocus()
Me.Parent!Subform_2.Form!Field1.SetFocus
End Sub

I've set the Form Cycle in the Property Sheet to be Current Record, so at the moment, when tab is pressed on the last field, it goes back to the first field but ideally, I'd like to to move to the first field on the next subform.

Should this Form Cycle Property be changed?

Thanks in advance.

[June7]

Instructions say have to execute 3 command lines to set focus to specific control on other subform.

[Shadows1989]

Instructions say have to execute 3 command lines to set focus to specific control on other subform.

Apologies, obviously missed that.

I changed my code to:

Private Sub Field5_LostFocus()
Me.Parent.SetFocus
Me.Parent!Subform_2.Form.SetFocus
Me.Parent!Subform_2.Form!Field1.SetFocus
End Sub

But I get the following error when tabbing from the Field5:

Run-time error '2449':

There is an invalid method in an expression

I click on Debug and the following is highlighted in error:

Me.Parent!Subform_2.Form.SetFocus

Any ideas?

[Micron]

Is one subform nested in the other, or are they both on the main form? Is either of the subforms on a tab control? I believe the code you're trying was not meant for nested subforms - not sure about subform on tab control (have not had coffee yet). Also, the control you want to set focus to cannot be hidden (not sure about disabled). Make sure it can accept focus.

I would try using an explicit reference by way of the actual forms hierarchy rather than Parent:

[Forms]![Main form name]![subform control name].[Form]![control name on subform]

[June7]

According to example, remove .Form - should be:

Me.Parent!Subform_2.SetFocus

Code works for me.