setting focus in a subform

[UsingTime]

When tabbing out of a text box "txtWeight" on a main form "frmOrdersMain", I would like to have the focus set to combo box "ItemID" on a subform "frmOrderDetails".

I was thinking of putting the code as an "OnExit" event. Would that be right, and what would that code look like?

Any help is appreciated!

[Mark L]

If you only want to do this if you tab-out of txtWeight, I'd create a transparent command button, setting its tabIndex property to be the next control after txtWeight. Then in the OnEnter event of this new control, I'd have this code:

Code: Select all

frmOrderDetails.setfocus
frmOrderDetails.form.ItemID

This assumes that the subform control name is frmOrderDetails.

[HansV]

I think Mark forgot a SetFocus and meant to post

frmOrderDetails.SetFocus
frmOrderDetails.Form.ItemID.SetFocus

As Mark mentioned, you should use the name of the subform as a control on the main form. This is not necessarily the same as the name of the subform in the database window.