Combo boxes

T

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??
 
R

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
 
T

Tray

That's great, thank you!

Roger Converse said:
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
Click to expand...
 
J

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??
Click to expand...

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

John W. Vinson [MVP]
 
Top