Microsoft Office Tutorials and References
In Depth Information
Configuring the Whole Form or Report
If the properties in the property sheet look strange, you’re probably looking
at the properties for part of the form or maybe just one control on the form.
The property sheet displays the properties of whatever part of the form is
selected. To see the properties of the entire form, set the Selection Type
drop-down menu to Form. Chapter 2 of this minibook describes setting
properties for individual controls.
Naming the form
Every form has a name, and that name usually appears on the object tab for
the form when the form is open. You can provide a different name to appear
on the object tab, however. This feature is useful when your form name isn’t
very user-friendly. To change the caption — the name on the tab — change
the Caption property, which is on the Format tab of the property sheet.
When the Caption property is blank, Access uses the form name, but you
can type something else.
Seeing where records come from
When you created your form or report, you (or an Access wizard) chose the
record source — the table or query that provides the records to display.
You rarely want to change the record source; if you want to use different
data, you may as well start with a new form or report.
To see or change the record source, follow these steps:
1. Open the form or report in Layout or Design view.
2. Display the property sheet with the properties for the forms.
3. Click the Data or All tab of the property sheet.
Whichever tab you click, the first property listed is Record Source,
which shows the name of the table or query from which the form or
report displays records.
4. To change the record source, click the down arrow at the right end of
the Record Source property and choose a different table or query
from the drop-down menu.
5. If the form or report is based on a query, and you want to modify that
query, click the Expression Builder button — the ellipsis ( ... ) button
to the right of the Record Source property.
See Book III for details on how queries work.
If you’re going to change the record source, do it before you spend a lot of
time working on the design of the form. Having the correct record source
makes creating and editing your form or report much easier, because Access
already knows what fields may appear on it.