Combo Box

  • Thread starter Thread starter Rob
  • Start date Start date
R

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.
 
Rob,

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

SELECT DISTINCT BoxNumber FROM BoxTable

-Andy
 
Back
Top