Specify which record source of a page supports edits

Microsoft Office Access 2003

Show All Show All

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.

  1. Open the data access page in Design view.
  2. Double-click the header section that contains the editable fields.
  3. On the Data tab, in the UniqueTable property box, select the table you want.