Change Text Field into a Drop Down Box

[Dan Pickard]

Hi,

I have a form with a series of text fields on it with about 500 records in
the database. I want to turn one of the text fields into a drop down list
box and only take the unique values from the field column.

Can I do this? and if so, any pointers?

Many thanks

--
Dan Pickard
-----------------------------
Powerful Windows 2003 web hosting, design and training.
http://www.hosting.fast-trak.net
http://www.design.fast-trak.net
http://www.training.fast-trak.net
http://www.fast-trak.net

 

[Roger Carlson]

In Design view of the form, right-click your text box and choose Change
To...Combobox.

You will get some new properties. One of them is RowSourceType. Make sure
this is Table/Query. Another property is RowSource. When you click in that
property, you will find a Builder Button [...]. Click that and create a
query that returns the records you want.

To remove duplicates, you can either switch to SQL View and add the word
DISTINCT after SELECT (SELECT DISTINCT * from ...) OR right-click in the
Table area of the Query Builder, choose Properties and set the UniqueValues
property to Yes.

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Dan Pickard]

Thanks that is perfect.

--
Dan Pickard
-----------------------------
Powerful Windows 2003 web hosting, design and training.
http://www.hosting.fast-trak.net
http://www.design.fast-trak.net
http://www.training.fast-trak.net
http://www.fast-trak.net

In Design view of the form, right-click your text box and choose Change
To...Combobox.

You will get some new properties. One of them is RowSourceType. Make
sure
this is Table/Query. Another property is RowSource. When you click in
that
property, you will find a Builder Button [...]. Click that and create a
query that returns the records you want.

To remove duplicates, you can either switch to SQL View and add the word
DISTINCT after SELECT (SELECT DISTINCT * from ...) OR right-click in the
Table area of the Query Builder, choose Properties and set the
UniqueValues
property to Yes.

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi,

I have a form with a series of text fields on it with about 500 records
in
the database. I want to turn one of the text fields into a drop down
list
box and only take the unique values from the field column.

Can I do this? and if so, any pointers?

Many thanks

--
Dan Pickard
-----------------------------
Powerful Windows 2003 web hosting, design and training.
http://www.hosting.fast-trak.net
http://www.design.fast-trak.net
http://www.training.fast-trak.net
http://www.fast-trak.net