Access 101: Bound vs. Unbound Forms

Mike Wolfe -

This article is part of my Quick Start Guide to Microsoft Access series, Access 101.

A bound form displays data from a table or query.

An unbound form is not connected to a data source at all.

In practical terms, a bound form is one with a RecordSource property set, while an unbound form's RecordSource property is blank.

Of course, this raises an obvious question: What is a record source?

Record Source

A record source identifies the data source that a bound form is connected to.

The three most common types of record sources are:

  1. Table Name
  2. Query Name
  3. SQL SELECT statement

As you navigate through the form, you're essentially navigating through the records in the record source.

Common Use Cases

Bound Forms

  1. Editing Records
  2. Master Lookup Forms
  3. Tabbed Master-Detail Forms
  4. Progress Tracker Form

Unbound Forms

  1. Menu / Navigation Forms
  2. Report Preview Forms
  3. "Get Data" Forms
  4. "Add Record" Forms
  5. Two-Way Many-to-Many Forms

Acknowledgements
  • Portions of this article's body generated with the help of ChatGPT