Home > DeveloperSection > Articles > Navigate in sub datasheets shortcut keys for MS Access

Navigate in sub datasheets shortcut keys for MS Access


Shortcut Keys Shortcut Keys 
Ratings:
0 Comment(s)
 1635  View(s)
Rate this:

Navigate in sub datasheets shortcut keys for MS Access

In this article I am trying to explain the shortcut keys for Navigate in sub datasheets in MS Access.

Going to a specific record

Key

Description

F5

From the subdatasheet to move to the record number box; then type the record number and press ENTER

Expanding and collapsing subdatasheet

Key

Description

CTRL+SHIFT+DOWN ARROW

From the datasheet to expand the record’s subdatasheet

CTRL+SHIFT+UP ARROW

To collapse the subdatasheet

Navigating between the datasheet and subdatasheet

Key

Description

TAB

To enter the subdatasheet from the last field of the previous record in the datasheet

SHIFT+TAB

To enter the subdatasheet from the first field of the following record in the datasheet

CTRL+TAB

To exit the subdatasheet and move to the first field of the next record in the datasheet

CTRL+SHIFT+TAB

To exit the subdatasheet and move to the last field of the previous record in the datasheet

TAB

From the last field in the subdatasheet to enter the next field in the datasheet

DOWN ARROW

From the datasheet to bypass the subdatasheet and move to the next record in the datasheet

UP ARROW

From the datasheet to bypass the subdatasheet and move to the previous record in the datasheet

               


Don't want to miss updates? Please click the below button!

Follow MindStick