[MaMister]

I am creating a database using access 2003 for myself.

Everything I key in a new record I have to manually type in the name in the first field, it is time consuming if the name is long.

So I created a drop down list.

I wanted to get the data on my "name" field, so during the list creation I choose the option:
"I want the list box to look up the values in a table or query"

Then I realised that the names that I key in few times all appear in the list box...:
Eg.
Francis. T
Francis. T
Francis. T
Sean. S
Sean. S
Sean. S
Michelle. G
Michelle. G

For Francis. T I had key in 3 records and Sean 3 records and so on.

Is it possible to tap on the exisiting name field values but only display 1 name of its type?

[Advertisements]

MaMister,
There are a number of ways to setup list boxes and combo boxes
It depends how and where you store and recall the data

the following links will provide more detail
http://www.fontstuff...ss/acctut11.htm
http://www.fontstuff...ss/acctut20.htm


HTH

dsm

[dsm]

MaMister,
There are a number of ways to setup list boxes and combo boxes
It depends how and where you store and recall the data

the following links will provide more detail
http://www.fontstuff...ss/acctut11.htm
http://www.fontstuff...ss/acctut20.htm


HTH

dsm

[MaMister]

Thanks.

I found the solution, it is SELECT DISTINCT under query.

Hope this help others too...