Specify which record source of a page supports edits
When a data access page includes fields from multiple tables, or from a query that includes fields from multiple tables, you can choose the table whose fields can be edited in Page view or in Microsoft Internet Explorer.
- Open the data access page in Design view.
- Double-click the header section that contains the editable fields.
- On the Data tab, in the UniqueTable property box, select the table you want.