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

  Modified On Nov-30-2017 06:30:15 AM

Leave Comment