---
title: "Navigate in sub datasheets shortcut keys for MS Access"  
description: "In this article I am trying to explain the shortcut keys for Navigate in sub datasheets in MS Access."  
author: "Vijay Shukla"  
published: 2013-04-04  
updated: 2017-11-30  
canonical: https://www.mindstick.com/articles/1225/navigate-in-sub-datasheets-shortcut-keys-for-ms-access  
category: "shortcut keys"  
tags: ["shortcut keys"]  
reading_time: 2 minutes  

---

# Navigate in sub datasheets shortcut keys for MS Access

In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I am trying to [explain](https://www.mindstick.com/forum/159699/what-is-a-compilation-error-in-dot-net-core-explain-with-an-example) the [shortcut keys](https://www.mindstick.com/blog/477/shortcut-keys-for-formatting-elements-in-pivottable-view-for-ms-access) 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](https://www.mindstick.com/articles/13054/here-s-how-crm-can-help-you-expand-your-business) 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](https://www.mindstick.com/forum/157521/store-the-previous-record-in-its-history-table-before-updating-it-in-the-sql-table-using-a-trigger) 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](https://www.mindstick.com/blog/301063/how-risky-is-a-heart-bypass-surgery) 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 |

---

Original Source: https://www.mindstick.com/articles/1225/navigate-in-sub-datasheets-shortcut-keys-for-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.