GoToRecord from one subform to another

[TheWedgie]

GoToRecord from one subform to another (solved)

Now, hoping I can explain this ok...

Main form 'DataEntry', has two subforms.
One is for the actual data entry (subform1).
The other is a Continuous Forms view form that shows a filtered set of records from the table, call it subform2.

What I want to do is add a button to the Continuous Form of subform2 that will locate the particular record in subform1.

EDIT: Solved it... had to set the focus on the other subform first, rather than try and reference it from the GoToRecord command...

Used this as the code behind OnClick for the command button:

Parent.subform1.SetFocus
DoCmd.GoToRecord , , acGoTo, Me.Job_Number.Value

 

[ajetrumpet]

congrats on figuring this out wedgie. that's exactly what i am saying here:

http://www.access-programmers.co.uk/forums/showthread.php?goto=newpost&t=167178