Tab Order in Subforms

[Harold via AccessMonster.com]

I have two subforms on one form. One being the Parent of the other. When I
tab through the Parent subform I would like the focus to move to the child
subform after I tab from the current record on the Parent subform. What is
happening is the focus will tab down through all the records in the Parent
subform and then will go to the first record in the Child subform. The
problem is that I would like to keep the focus on the current record in the
Parent subform and then tab right to the Child records of that record in the
Child subform.

I hope this makes sense.

Thanks,
Harold

 

[Baz]

I have two subforms on one form. One being the Parent of the other. When I
tab through the Parent subform I would like the focus to move to the child
subform after I tab from the current record on the Parent subform. What is
happening is the focus will tab down through all the records in the Parent
subform and then will go to the first record in the Child subform. The
problem is that I would like to keep the focus on the current record in the
Parent subform and then tab right to the Child records of that record in the
Child subform.

I hope this makes sense.

Thanks,
Harold

In the parent form's properties, set the Cycle property to "Current Record"

 

[Harold via AccessMonster.com]

Thank you!!

I have two subforms on one form. One being the Parent of the other. When I
tab through the Parent subform I would like the focus to move to the child

[quoted text clipped - 9 lines]

Thanks,
Harold

In the parent form's properties, set the Cycle property to "Current Record"

 

[Harold via AccessMonster.com]

It still seems to tab to the next record in the subform. I have a main form
and a subform thats its child and a subform that a child to it. I need to be
able to enter a new record into all three without it tabbing to a new record
half way through the process.

Thanks for your help

Harold

I have two subforms on one form. One being the Parent of the other. When I
tab through the Parent subform I would like the focus to move to the child

[quoted text clipped - 9 lines]

Thanks,
Harold

In the parent form's properties, set the Cycle property to "Current Record"

 

[Baz]

It still seems to tab to the next record in the subform. I have a main form
and a subform thats its child and a subform that a child to it. I need to be
able to enter a new record into all three without it tabbing to a new record
half way through the process.

Thanks for your help

Harold

Make sure that, for the subform controls, the Tab Stop property is set to
"Yes"