Using the right arrow to move between subforms

[Guest]

I have code that upon exit of the field will jump to the next spot on the
form the user is using. The form LOOKS like fields across the page, when
actually they are seperate subforms they are entering data into.

Private Sub Make_Exit(Cancel As Integer)
On Error GoTo Err_Make_Exit
Me.Parent.Frm_DMI_MPH_2.SetFocus
Me.Parent.Frm_DMI_MPH_2.Form.Make.SetFocus
Exit_Make_Exit:
Exit Sub
Err_Make_Exit:
Resume Exit_Make_Exit
End Sub

This works well... expect that the user has to use the tab key or enter to
exit the field. They would like to be able to use the right arrow.
How do I get the right arrow to act like a tab in that field?
Thanks,
Tammy

 

[Guest]

In the Menu Bar select Tools > Options > Select the Tab "KeyBoard" > there
you have an option to select to specify how you want the errow key to beave.

Change it to move to next field