After you have created a form or report, you can modify its source of data to include or exclude one or more fields, columns, tables, or queries (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, report, or data access page.). Changing the record source will change the contents of the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.).

1. Open the form or report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
2. Double-click the form selector (form selector: The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form.) or the report selector (report selector: The box where the rulers meet in the upper-left corner of a report in Design view. Use the box to perform report-level operations, such as selecting the report.) to open the property sheet.
3. Do one of the following:
   • To include all fields or columns from a single table or query in the record source, click the arrow in the RecordSource property box to select from a list of tables and queries.
   • To base the form or report on certain fields or columns, or on more than one table or query, click the Build button next to the RecordSource property to open the query.