Move from subform to mainform

[reidhaus]

I want to move from the last control of my subform back to a control on the main form WITHOUT opening up a new record on the main form.

Right now I have coded:

Me.Parent.Form![Subtotal].SetFocus
DoCmd.GoToRecord

This almost works - it takes me to the correct control on the main form but on a new main form, not the one I was working on. Can someone help tweak my code?

 

[boblarson]

Why do you have DoCmd.GoToRecord? Doesn't it work to just use the set focus? It should.

 

[reidhaus]

You Are Brilliant! Thank You So Much:~)

I am so very, very thankful.

 

[boblarson]

Glad we could help. And, Welcome to Access World Forums, by the way.