[AccessD] Tabbing to Another control

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?




More information about the AccessD mailing list