Access 2002 Programming by Example

Dealing with the Underlying Records

To properly explore how the underlying records relate to a form, the best place to start is the Record Source property. Both tables and queries tied to forms through the Record Source property use updateable record sets. The fields available to the form depend on the table or query that is tied to the form. This list can be expanded in a number of ways. One way is to add another table to the select query that is attached to the form. Another method is to create a lookup control that relies on another table for its fields. These fields then become available through code using the column property.

Multiple Table Queries as Record Source

If your form is tied to a select query that is based on one table, there ...