form focus confusion

[mark kubicki]

on a form I have a tab control
behind the form is this code (referring to the tab control):

Private Sub Form_Activate()
Me.pgDATA.SetFocus
End Sub

on one of the pages (not pgDATA) I have a command button that opens another
form

the problem is that when I close the second form I want the main form focus
to remain on the page calling that 2nd form; but instead it returns to the
pgDATA (which actually is what I'm asking it to do, but don't want . ...well
the default should be to return to pgDATA, except...)

-thanks in advance,
mark

 

[missinglinq via AccessMonster.com]

In the command button that opens another form, after it does this, place the
focus back on the calling page.