Setting the focus to a field on a subform within a tab control

[gaugust]

I have a form called frmMain with a tab control called TabCtl0 and a subform
within the tab control called frmScreening. I would like to set the focus to
a field called txtserial when a new record is added. I have tried the
following 2 lines, but neither work:

[Forms]![frmMain]![frmScreening].Form![txtserial].SetFocus

and

Forms!frmMain!TabCtl0.Pages(1).txtserial.SetFocus

Would you know the proper syntax. Thanks.

 

[Marshall Barton]

I have a form called frmMain with a tab control called TabCtl0 and a subform
within the tab control called frmScreening. I would like to set the focus to
a field called txtserial when a new record is added. I have tried the
following 2 lines, but neither work:

[Forms]![frmMain]![frmScreening].Form![txtserial].SetFocus

Where are you tring to do this?

If it's in the main form, try this:

Me.frmScreening.SetFocus
Me.frmScreening.Form!txtserial.SetFocus

If it's from inside the subform:

Me.txtserial.SetFocus

 

[Analyst72]

First set the focus to the subform frmScreening using this
Forms.Item("frmMain").Controls("frmScreening").SetFocus

Then set the focus the txtSerial control on frmScreening using this
Forms.Item("frmMain").frmScreening.Controls.Item("txtserial").SetFocus

 

[boblarson]

Hey Analyst72, did you know that you can use

Forms("frmMain").Controls("txtSerial").SetFocus

instead of adding the word Item into each of those?
--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

First set the focus to the subform frmScreening using this
Forms.Item("frmMain").Controls("frmScreening").SetFocus

Then set the focus the txtSerial control on frmScreening using this
Forms.Item("frmMain").frmScreening.Controls.Item("txtserial").SetFocus

I have a form called frmMain with a tab control called TabCtl0 and a subform
within the tab control called frmScreening. I would like to set the focus to
a field called txtserial when a new record is added. I have tried the
following 2 lines, but neither work:

[Forms]![frmMain]![frmScreening].Form![txtserial].SetFocus

and

Forms!frmMain!TabCtl0.Pages(1).txtserial.SetFocus

Would you know the proper syntax. Thanks.

 

[gaugust]

I am trying to do this in the main form. Using the code you provided it now
works. Thanks Marshall.

I have a form called frmMain with a tab control called TabCtl0 and a subform
within the tab control called frmScreening. I would like to set the focus to
a field called txtserial when a new record is added. I have tried the
following 2 lines, but neither work:

[Forms]![frmMain]![frmScreening].Form![txtserial].SetFocus

Where are you tring to do this?

If it's in the main form, try this:

Me.frmScreening.SetFocus
Me.frmScreening.Form!txtserial.SetFocus

If it's from inside the subform:

Me.txtserial.SetFocus