[AccessD] Tabbing to Another control

Just a quick thing. Did you double check the NAME field is what you think it is? Often the SOURCE OBJECT has the name you want and the NAME has something stupid like combobox1.

Sorry if you have already done this, but it just seems like the place to start.

cheers
Darryl.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
Sent: Monday, 19 May 2008 12:25 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Tabbing to Another control


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?

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.