Database Reference
In-Depth Information
18
In the pane, click the
Data
tab. Then click the
Control Source
arrow, and in the list,
click
Country
to bind the combo box control to the
Country
field in the
Customers
table.
19
Verify that the
Row Source Type
property is set to
Table/Query
. Then in the
Row
Source
box, enter the following:
SELECT DISTINCT Customers.Country FROM Customers;
Be sure to include the period (but no space) between
Customers
and
Country
, and
the semicolon at the end of the text. (The words in capital letters are instructions and
the remaining words are variables that identify the field and the table to which the
instructions should be applied.)
To display the entire query, you can widen the Property Sheet pane by dragging its left border
to the left.
20
Click the combo box label control. Click the
Format
tab of the
Property Sheet
pane,
and change the
Caption
property to
Country
.
