Move from subform back to Main Form Help Needed

[TK]

I have an invoice form. On it I have a subform where you can enter more
than one item. It's defalt view is set to Datasheet. Sometimes only one
entry will be made on this subform, other times as many as six entries may
be entered. Is there a keyboard shortcut to make the cusor jump from the
subform back to the main form to one last field at bottom of the form?

Any help would be much appreciated.

TK

 

[Allen Browne]

You can do this without code, by creating a keyboard shortcut for the field
on the main form you wish to jump back to.

Say the field is called "Comments", and you want to use Alt+C to jump to
that field. Change the Caption property of the label attached to the text
box to:
&Comments
Access shows this as an underlined C, and you can jump to that field with
Alt+C.

 

[TC]

Give that last main form field a label. Make sure the label is "attached" to
that field, not just floating free. Include an ampersand (&) somewhere in
the label caption - for example, "Final &Value". Now, pressing Alt and that
letter (eg. Alt V) should move directly to that field.

HTH,
TC

 

[Joan Wild]

Is there a keyboard shortcut to make the
cusor jump from the subform back to the main form to one last field
at bottom of the form?

Ctrl-tab will take you out of a subform back to the main form to the next
control in the tab order.