Show All

Bind a blank form or report to one or more tables or queries

1. Set the record source of the form or report.

   How?

   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. Changing the record source will change the contents of the field list.

   1. Open the form or report in Design view.
   2. Double-click the form selector or the report selector 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.
2. Use the field list to add controls bound to the underlying fields or columns to the form or report.