Combo Box

[Rob]

I have a combo box that is based on a value in a field in
a table. The user will be able to use the combo box to
select the value. I do not want duplicate values showing
in the combo box. i.e. In the field named "Box#" there
may be a thousand entries of "555". For my purpose when
the user selects the combo and there is a drop-down list I
do not want to see a thousand entries of "555". They
just need to see "555" once. I do not want enter all Box#s
in the Row Source because it is alot of box numbers and
all ways needs to be updated. Any Help. Thanks.

 

[Andy Williams]

Rob,

In the RowSource for the combo box, try something like this:

SELECT DISTINCT BoxNumber FROM BoxTable

-Andy