Combo boxes

[Tray]

Hi
I've created a combo box, and have used a numeric field in a query as its
source. What I want to do though is make sure each number is only listed once
in the combo dropdown.
i.e. it shows 10,11,13 instead of 10,10,10,11,11,10,11,13,13,13

Is there anyway of doing this??

 

[Roger Converse]

If you use a group by query (i.e. click on the summation sign - funky looking
E) and set that query as your combo box row source. Then the number will
only show up once.

HTH
Thanks,
Roger

 

[Tray]

That's great, thank you!

If you use a group by query (i.e. click on the summation sign - funky looking
E) and set that query as your combo box row source. Then the number will
only show up once.

HTH
Thanks,
Roger

 

[John W. Vinson]

Hi
I've created a combo box, and have used a numeric field in a query as its
source. What I want to do though is make sure each number is only listed once
in the combo dropdown.
i.e. it shows 10,11,13 instead of 10,10,10,11,11,10,11,13,13,13

Is there anyway of doing this??

Base the combo on a Query with its Unique Values property set to Yes.

John W. Vinson [MVP]