Help with setting focus in subform 1

[mytaurus2000]

I have a subform frmsubform, and main form, mainForm.

When the user enters address info in the subform, I would like the focus to move to the text field in subform txtPhone. I have tried it two ways, one with

Me![frmsubform].SetFocus
Me![frmsubform].Form![Home Phone].SetFocus

And I receive a runtime error 2465 saying can't find control I'm referencing.

Then I tried

Forms!frmsubform.[Home Phone].SetFocus

And it tells me it can't find frmsubform

How can I reference a field in my subform from my main form.

 

[LarrySteele]

Good question. Navigating around forms, subforms, and sub-subforms is not as straightforward as you might expect. Here's a link to a table that I use when trying to figure out the correct syntax:

http://www.mvps.org/access/forms/frm0031.htm.

HTH,
Larry

 

[mytaurus2000]

Larry,

Thank you for your help, that page is most definitely in my Favorits now.