goto subform from subform

[LCalaway]

I have a main form (frmDeeds) and two subforms (frmGrantorSubform)
(frmGranteeSubform). Each is tied to its own table tblDeeds, tblGrantee,
tblGrantor. The grantor and grantee tables are related to the deed table by
the same field name DeedID.

I am not able to go from the last field in frmGrantorSubform to the first
field in frmGranteeSubform.

The last field in frmGrantorSubform: table name = InputterComment, form
name = txtInputterComment
The first field in frmGranteeSubform: table name = EELName, form name =
txtEELName

I have tested a couple of ways to do this, and I fail. These include the
"After Update" and "On Exit" events.

Would appreciate help, please.
Thank you.
LCalaway

 

[scubadiver]

How is Access supposed to distinguish between when you have not finished
entering records in the grantor table as opposed to wanting to move to the
grantee table?

Is there a reason in having two separate table?

 

[LCalaway]

When I tab between fields on the grantor subform, the tab key carries me to
the next available field in the same record. When I get to the end of the
record, the tab key carries me to the first field of the next record in the
grantor subform. When I have exhausted the available fields in view on the
grantor subform and press the tab key, I am sent to the LAST field in the
grantee subform instead of the first field in the grantee subform.

I created a macro to jump back and forth between the subforms. This works
but i would also like to have the action of tabbing when in the last field
of the record in the grantor subform to take me to the FIRST field in the
grantee subform instead of the LAST field.

The reason for separate tables is because there are often numerous grantees
and/or grantors for each transaction. Done in separate tables seemed to be
the way to avoid having the data entry person from indicating whether the
name was a grantee or a grantor.

LCalaway

 

[scubadiver]

What does you macro look like?

 

[LCalaway]

Macro Name = GoToOR
Steps in the Macro
GoToControl: frmGrantorSubform
ToToControl: txtORLName

The Macro is invoked by the key combination <ctrl>R. It works as
programmed.

The Macro to go to the Grantee subform is programmed similarly.
LC