totn Access 2010 Forms

MS Access 2010: Record Source for Form

This MSAccess tutorial explains the Record Source property for a form in Access 2010 (with screenshots and step-by-step instructions).

Record Source property

Let's take a few moments to explore some of the more commonly used properties for a Form object in Access 2010.

The Record Source property sets the source of the data for the form.

For example, if you want to create a data entry form for the Products table, you would specify Products as the Record Source. This means that if you add a new record in the form, it will insert a record into the Products table. If you modified a record within this form, the data in the Products table would also be modified.

The Record Source property can be set to a table name, query name, or you can build your own SQL statement by invoking the Query builder (ie: clicking on the button with the three dots to the right of the Record Source property)

Microsoft Access