Cycle property of subform doesn't perform as advertised ???

[Guest]

I prefer that user can remain on the subform rows when editing (use CTL+TAB
to return to parent).
I find that none of the settings of the Cycle property has any effect.
Tab on last column of last row returns focus to next control in
parent's tab order.

MSDN quote:
Note The Cycle property only controls the TAB key behavior on the form
where the property is set. If a subform control is in the tab order, once the
subform control receives the focus, the Cycle property setting for the
subform determines what happens when you press the TAB key.

Please see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acproCycle.asp

 

[Allen Browne]

Peter, something else must be going on in this scenario.

The normal behavior in Access is that the focus stays in the subform until
you move it back to the main form. That is true regardless of how the
subform's Cycle property is set, i.e. the Cycle property only determines
whether you stay in the same subform record or move to the next subform
record.

Perhaps there is code or a macro attached to one of the events of the last
text box or of the form itself to SetFocus back to the main form. Or perhaps
some process is forcing a requery.