Drop-Down Box use in a form.

[Guest]

I am trying to create a from to use to enter data into a table. One of the
data entries is called "Area" There are five areas which are actually city
names. I have created all types of drop down boxes (combo box, list box,
drop down list box, etc.) but cannot figure out how to populate the box with
the five city names to choose from.

 

[Guest]

hi,
have you tried setting the combo box's row source to a
query that selects the five cities?

 

[Guest]

I tried that. In the query I set the UniqueRecords property to YES, but it
still showed multiple accounts of the cities. I tried setting the
UniqueValues to YES, and the same thing happened.
So, now I have the drop down box populated with a list of cities, but it
shows the same city listed multiple times.

 

[Guest]

Hi Jim,

You can set the values for a combo box field in the actual table. This may
work best for you since you only have 5 values.

To do so:

1. Open the table in design view.
2. Select your field.
3. Click on the Lookup tab in the Field Properties section.
4. Enter the following: Display Control = Combo Box; Row Source Type =
Value List; Row Source = {type your 5 areas here...seperated by a semi colon}
This list of values will now be attached to this field.

Best Regards,
Faye Somdahl [MSFT]

 

[Guest]

hi agin,
use faye way.
good luck

-----Original Message-----
Hi Jim,

You can set the values for a combo box field in the actual table. This may
work best for you since you only have 5 values.

To do so:

1. Open the table in design view.
2. Select your field.
3. Click on the Lookup tab in the Field Properties section.
4. Enter the following: Display Control = Combo Box; Row Source Type =
Value List; Row Source = {type your 5 areas

here...seperated by a semi colon}

This list of values will now be attached to this field.

Best Regards,
Faye Somdahl [MSFT]

hi,
have you tried setting the combo box's row source to a
query that selects the five cities?
a
table. One of the which
are actually city

.