David Emerson
newsgrps at dalyn.co.nz
Sun May 18 21:24:40 CDT 2008
I have a form called frmClient.
On it is a tab called tabClient.
On tabClient is a subform called sfrClientRevision
On sfrClientRevision is a tab called tabRevision with two pages -
pgeSaving and pgeBudget
On pgeSaving is a subform called sfrClientInvestment
On sfrClientInvestment is a field called cboInvestmentType
On pgeBudget is a subform called sfrClientBudget
On sfrClientBudget is a tab called tabCashFlow
On tabCashFlow is a page called pgeSummary
On pgeSummary is a field called txtpgeSummaryLast
What I would like to do is this: When txtpgeSummaryLast is tabbed
into, then the focus automatically moves to cboInvestmentType.
What I have tried on the OnEnter event of txtpgeSummaryLast is this:
DoCmd.GoToControl "sfrClientRevision"
DoCmd.GoToControl "tabRevision" <-- Error here
DoCmd.GoToPage "pgeSaving"
DoCmd.GoToControl "sfrClientInvestment"
DoCmd.GoToControl "cboInvestmentType"
The error message I get is No 2109: There is no field named
"tabRevision" in the current record.
I have also tried:
Forms!frmClient.SetFocus
Forms!frmClient!sfrClientRevision.SetFocus
Forms!frmClient!sfrClientRevision.Forms!sfrClientInvestment.SetFocus
<-- Error here
The error message I get is No 438: Object doesn't support this
property or method.
How can I get from txtpgeSummaryLast to cboInvestmentType?