Auto select 1st row of subform on tabed form

[vanessa03]

Once again I thank all who contribute their knowledge here, because without this forum, who knows how long it would have taken me to do this project. Now the problem..
I have a tabbed form and when the user clicks on page 2 I want the program to automatically select the 1st row of the subform. This subform on page 2 is linked to another subform on the same page. Everything works fine if I click on the subform, but I want it to automatically click on the 1st row when you go to that page. I want to call subform click event, but can't seem to figure out how or where to do this. This is what I have tried so far:
Private Sub TabCtl0_Change()
With Forms![frmPPInventory]
If !TabCtl0 = 1 Then
!fsubPPOrderHeaderToBeQCd!.Form_Click
End If
End With
It gives me the error: object does not support this property or method. Thanks for your help.

 

[PHV]

What about replacing this:
!fsubPPOrderHeaderToBeQCd!.Form_Click
with this ?
!fsubPPOrderHeaderToBeQCd.Form.Requery

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

 

[vanessa03]

Thanks but no cigar. It doesn't give me an error now, but it does not do what I want it to do. I need the first row of the subform clicked (need to call the click event of the subform). Any other ideas?