Bind a blank form or report to data in a table or other record source

Bind a blank form or report to data in a table or other record source

  1. In form Design view or report Design view, double-click the form selector or the report selector to open the property sheet.

  2. Click the arrow next to the RecordSource property box and select from a list of tables or queries.

  3. Use the field list to add controls bound to the fields in the record source to the form or report.

Switch to Form view or Datasheet view to see the data in the form. Switch to Print Preview to see the data in the report.