trouble setting focus to Subform Control

[Ziggy1]

I've looked over this link, but i can't get the syntax right.... this is what I have before looking at the link....

Me.tblArticleDetail_subform.SetFocus

It will set the focus to the subform, but I want to set focus to a control on that form but can't figure it out.


i thought this should work...


Private Sub Skid_Type_AfterUpdate()

Me.tblArticleDetail_subform.Form.Article.SetFocus

End Sub



thanks

 

[pbaldy]

Try 2 lines, the first setting focus to the subform itself, the second to the particular control on that subform.

 

[Ziggy1]

arghhh LOL that was too easy.... I just didn't think I needed 2 lines, thanks for the help.


Private Sub Skid_Type_AfterUpdate()
Me.tblArticleDetail_subform.SetFocus

Me.tblArticleDetail_subform.Form.Article.SetFocus

End Sub