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 |
Leave Comment