Dynamic Combo Box Based on Field Contents 2

[wreded]

i know i've seen this someplace but i can't seem to find it now that i need it.
How can i create a dynamic combobox composed of the UNIQUE data in a field? For example: Field contains text data in the form of "0015" to "0095". There are 15 records with "0015", 25 records with "0035", and 3 records with "0095". Rather than display all 43 records is there a way i can filter the combobox to just display the 3 UNIQUE data in the field ("0015", "0035", and "0095").

 

[MajP]

You can manually put the DISTINCT predicate in the sql string,
"Select DISTINCT fldName from someTable"

or if working in the query builder right click and should get a property "Display Distinct Values

 

[MazeWorX]

when you populate the Combo with a query use SELECT DISTINCT

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[MajP]

if using the properties window it is "Display Unique Values"

http://www.techonthenet.com/access/queries/unique_values.php

 

[MazeWorX]

lol i guess you type faster Maj

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[wreded]

MajP and MazeWorX --

Thanks!! i knew it had to be somewhere.

Dave