Combo Box Survival Guide Dale Dixon and Steven Parsons Microsoft Support Professionals Microsoft Dev

1
Combo Box Survival GuideDale Dixon and Steven
Parsons Microsoft Support ProfessionalsMicrosoft
Developer Support Microsoft Corporation
2
IntroductionCombo Box Survival Guide Topics

• Combo Box Described
• Uses of combo boxes
• Combo Box Properties
• Creating Combo Boxes
• How To Find or Move to Records
• Synchronizing Combo boxes
• Combo Box Quick Tips

3
Different Controls

• Text boxes, command buttons, check boxes
• Combo boxes

4
A Combo Box DescribedA combo box combines a text
entry field and a field list box.
Directional arrow
Text entry
List box selection
5
Combo Box PropertiesData tab
6
Combo Box PropertiesFormat tab
7
Creating Combo Boxes

• Two methods
• Wizard
• Manual

Wizard control
Combo box
8
Combo Box Wizard OptionsThree options
9
How To Find or Move to Records

• In the AfterUpdate property of the combo box, use
  the FindRecord action to find a record.
• In the AfterUpdate property of the combo box,
  call a macro using the ApplyFilter action.
• Use a Form/Subform, with the combo box in the
  main form and the data in the subform, bound by
  the LinkMasterFields and LinkChildFields
  properties.
• Base the form on a query that joins two tables,
  and use the AutoLookup technique to bind the
  combo box to the field that controls the join.

10
First Method (1) Using the AfterUpdate property
11
First Method (2)Code created
12
Second Method (1) Using the ApplyFilter
13
Second Method (2) Macro settings
14
Third Method (1)Link fields
15
Third Method (2) Create a new form
16
Third Method (3)Add a text box
17
Third Method (4)Create a second form
18
Third Method (5) Save the form
19
Third Method (6) View the main form
20
Fourth Method (1) Table properties

21
Fourth Method (2) Create a query
22
Fourth Method (3) Create a subform
23
Fourth Method (4)Morph the text box to a combo
box
24
Synchronizing Combo Boxes
25
Synchronizing Combo Boxes Create a query
26
Synchronizing Combo Boxes Combo box properties
27
Synchronizing Combo Boxes Created a macro
28
Combo Box Quick Tips

• How to make a combo box default to the first item
  in a combo box
• How to manipulate a combo box without a mouse
• How to automatically open a combo box

29
Knowledge Base Articles

• Q105519 - ACC How to Make a Combo Box Default to
  First Item in List
• Q209011 - ACC2000 How to Start Macros,
  Functions, and Applications from a Combo or List
  Box
• Q209595 - ACC2000 How to Synchronize Two Combo
  Boxes on a Form
• Q209537 - ACC2000 Four Ways to Move to a Record
  from a Combo Box Selection
• Q161007 - ACC Use NotInList Event to Add a
  Record to Combo Box (95/97)
• Q139039 - ACC How to Include a Null Selection in
  a Combo Box List

30
Microsoft Press Books

• Microsoft Access 2000/Visual Basic for
• Applications Fundamentals
• Author Evan Callahan
•  Programming Microsoft Access 2000
• Author Rick Dobson
•  Microsoft Access 2000 Step by Step
• Author Catapult, Inc.
•  Running Microsoft Access 2000
• Author John Viescas

31
(No Transcript)