Microsoft Access 2003 Illustrated Complete

1
Microsoft Access 2003Illustrated Complete
Developing Forms and Subforms
2
Objectives

• Understand the form/subform relationship
• Create subforms using the Form Wizard
• Create subforms using queries
• Modify subforms

3
Objectives

• Add a combo box for data entry
• Add a combo box to find records
• Add option groups
• Add command buttons
• Add ActiveX controls

4
Understand the form/subform relationship

• A form/subform is two form objects
• The main form contains the subform
• Use a form/subform to show a one-to-many
  relationship
• Use a form/subform to show a parent-child
  relationship

5
Understand the form/subform relationship

• The Record Source property of the form identifies
  the recordset, the fields and records a form will
  display
• The Record Source value may be
• Table
• Query
• SQL Statement

6
Understand the form/subform relationship
Main form
Subform
7
Create subforms using the Form Wizard
Choose table or query objects that contain
desired fields
Selected field list
8
Create subforms using the Form Wizard
Subform navigation bar
Main form navigation bar
9
Create subforms using queries

• Create the main form and subform as separate
  objects
• Add the subform to the main form using the
  Subform Wizard

Subform/Subreport button
10
Create subforms using queries

• A common field must be present in both the main
  form and subform to link the two forms
• The properties used to link a subform to a main
  form are these
• Link Child Fields
• Link Master Fields

11
Modify subforms

• You may modify forms and subforms in their
  individual Form Design Views
• You may modify forms and subforms in the Form
  Design View of the main form

12
Modify subforms
Main form
Subform
13
Add a combo box for data entry

• Use the Combo Box Wizard

Combo Box button
14
Combo Box Wizard
Choose one of the first two options to use the
combo box to enter data
15
Add a combo box to enter data
Combo boxes used to enter data
16
Combo Box Wizard
Choose the last option to use the combo box to
find records
17
Add a combo box to find records
Combo box used to find records
18
Add option groups

• Use the Option Group Wizard

Option Group button
Option Button button
19
Add option groups
Option group with four option buttons
20
Add command buttons

• Use the Command Button Wizard

Command Button button
21
Command Button Wizard
Actions within each category
Command Button categories
22
Adding command buttons
Command buttons
23
Add ActiveX Controls

• ActiveX is a Microsoft technology
• Microsoft and outside vendors write ActiveX
  controls
• ActiveX controls may be shared across applications

24
Add ActiveX Controls
ActiveX Controls vary based on the programs on
your computer
25
Summary

• Forms/subforms show related records
• Forms/subforms can be created with the Form
  Wizard or individually using the Subform Wizard
• Combo boxes, option groups, command buttons, and
  ActiveX controls may be added to a form to
  improve the forms functionality