Microsoft Office Tutorials and References
In Depth Information
Configuring the Whole Form or Report
If you use the new Application Part feature to create a blank form, as
described in the nearby sidebar, you need to set the Record Source
property before you can add field controls to the form.
Deciding the order of the records
You can also control the order in which records appear. You may want to
browse through an Address Book table by last name or by city, for example,
or through an Orders table by date. Normally, Access displays the records
in the same order as they appear in the record source. If the record source
is a table, records appear in primary key order from that table. If the record
source is a query, records are in the sort order specified in the query.
You can change the order of the records by changing the Order By
property of the form or report, which appears on the Data tab of the property
sheet for the form. Type the field name for the Order By property. If you
want the records to appear in reverse order, type a space and DESC after
the field name (for descending order).
Choosing one record or many
You usually want your form to show only one record at a time, like a paper
form. Most forms display one record at a time. The Address Book form in
Figure 1-1, earlier in this chapter, displays one record from an Address Book
table. Sometimes, though, you want to see more than one record at a time,
as in the form shown in Figure 1-8. (Reports use a different system to
determine whether one or many records appear in the report, as described in
Book V, Chapter 1.)
Figure 1-8:
one below
Search JabSto ::

Custom Search