How to?

[Selby]

How do I change where the cursor goes to when you close a subform? I need to
have it go to another location on the form when finished with the
subform........

 

[John W. Vinson]

How do I change where the cursor goes to when you close a subform? I need to
have it go to another location on the form when finished with the
subform........

You can set the Tab Order of the form containing the subform, so that the
other location is next after the Subform control in the tab order.

There are things you can do with VBA code and the SetFocus method, but they
shouldn't be required in this simple case.

Hrmmmm... do you really mean *A SUBFORM*? You don't usually "close" a subform.
Are you instead talking about a popup form, separate from the mainform?

 

[Maurice]

Depends on what's left open but you could use the setfocus option. From the
subform you can use the close event and then determine where you want the
focus to be.