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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...


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
 
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
 
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


Analyst72 said:
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


gaugust said:
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.
Click to expand...
Click to expand...
 
I am trying to do this in the main form. Using the code you provided it now
works. Thanks Marshall.

Marshall Barton said:
gaugust said:
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
Click to expand...


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
Click to expand...
 
Back
Top