A subdatasheet is a datasheet that is nested within another datasheet and contains data related or joined to the first datasheet. Microsoft Office Access automatically creates a subdatasheet when you create a table that is in a relationship (relationship: An association that is established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.). However, you can always add a subdatasheet to a table, query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.) or form (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.) (if the form is saved to be displayed in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.)).
This article describes how to identify a subdatsheet and remove it. Removing a subdatasheet does not delete the table, query, or form that it is connected to, nor does it modify any relationship between the associated tables.
What do you want to do?
Identify a subdatasheet
In Datasheet view, you can tell if a table, query, or form has a subdatasheet, because the expand indicator (+ sign) will be visible. If a subdatasheet is open, the expander sign changes to a - sign.
Subdatasheets can be nested in a subdatasheet for up to eight levels. The benefit of using a subdatasheet is that it enables you to see the information from more than one data source at the same time. For example, in the Northwind sample database, the Suppliers table has a one-to-many relationship (one-to-many relationship: An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.) with the Products table; so for each row of the Suppliers table in Datasheet view, you can view and edit the related rows of the Products table in a subdatasheet.
Top of Page
Remove a subdatasheet
- In Datasheet view, open the table or query that contains the subdatasheet that you want to remove.
- On the Records menu, click More, point to Subdatasheet, and then click Remove.
Top of Page