How to use a click event to go from a subform to main form

[rew2009]

I have a main form with tabbed pages and a subform on one of the pages that when I double click on a field on that subform I want it to leave that subform and take me to the main page of the main form. I used the following code to take me to the main page from other pages of the main form. However when I put it into a click event on the subform it doesn’t work.

Me.TabCtl0.Pages("MAIN").SetFocus

How do I do it from within the subform?

Thanks

 

[PHV]

I'd try this:

With Me.Parent.Form
  .SetFocus
  .TabCtl0.Pages("MAIN").SetFocus
End With

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886