Subform Set Focus

[dynamictiger]

I have a form with two subforms on it. The subforms are connected to the main record by client ID.

One of the subforms records phone numbers. The next subform contains address details.

I am trying to force the tab key to go from the phone number subforms last entry to the first entry in the address details subform.

I think I am having trouble with the syntax for the command, although frankly I am unclear.

 

[WayneRyan]

dynamictiger,

On the LostFocus of your PhoneNumber control put:

Forms!YourMainForm!YourAddressForm.SetFocus

btw,

I can see that a contact may have many phone numbers
and/or address, but shouldn't there be just one child
table containing a phone/address pairing?

hth,
Wayne

 

[dynamictiger]

I can see that a contact may have many phone numbers and/or address, but shouldn't there be just one child
table containing a phone/address pairing?

Not in this instance. In this instance the address is permanent, the contact is transient and can have as many phone numbers as you care to think of.

Appreciate your help.