Moving from subform back to mainform

[natalie]

I want to tab from the last record in my subform back over to the open main
form without opening a new record on the main form.

On Lostfocus I have coded:
Me.Parent.Form![Subtotal].SetFocus
DoCmd.GoToRecord

That takes me to the correct control, but on a new main form - not the
current main form. Any help in my coding would be greatly appreciated!

 

[boblarson]

Natalie:

I know you got the answer, but in case someone else needs it, here's where
the answer was given:

http://www.access-programmers.co.uk/forums/showthread.php?p=656980#post656980

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[natalie]

Wow, Bob! You are everywhere! The forums are very lucky to have you:~)

Natalie:

I know you got the answer, but in case someone else needs it, here's where
the answer was given:

http://www.access-programmers.co.uk/forums/showthread.php?p=656980#post656980

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

I want to tab from the last record in my subform back over to the open main
form without opening a new record on the main form.

On Lostfocus I have coded:
Me.Parent.Form![Subtotal].SetFocus
DoCmd.GoToRecord

That takes me to the correct control, but on a new main form - not the
current main form. Any help in my coding would be greatly appreciated!