Microsoft Office Tutorials and References
In Depth Information
Creating Forms with Wizards
Figure 1-3:
The Form
Wizard can
create a
form with a
subform for
from a
related table
or query.
6. Choose an organization scheme for your form by clicking the table or
query by which you want to group records.
In Figure 1-3, the form includes fields from the Customers table (which
contains a record for each customer) and the Orders table (with one
record for each order) from a business database. Do you want the form
to display one customer, with all the orders for that customer, or do
you want to display one order, with all its customers? (The second
option makes no sense, because each order is placed by only one
customer.) You decide by clicking an option in the list on the left side of the
7. Choose whether to include the second table or query as a subform or
as a second form.
If you choose the Form with Subforms option, you end up with one form,
with the records from the second table or query in a box (subform) on
the form. If you choose the Linked Forms option, you get two separate
forms, each in its own window, with a button on the first form that
displays the second form. When in doubt, try subforms. (See Chapter 4 of
this minibook for details on how subforms work.)
8. Click Next.
Access displays a window that asks you to choose the layout for the
subform, if you’re creating one; otherwise, skip to Step 10.
9. Choose the layout, and click Next.
You can click a layout option to see what it looks like. If you’re not sure
which option to use, stick with the Tabular layout; using and editing the
layout is easy.
10. Give the form a name, and if you created a subform or second form,
give it a name too.
This name is what Access uses when saving the form. The name doesn’t
have to appear on the form.
Search JabSto ::

Custom Search