combobox sort

[David Whitaker]

how would you sort and hide duplicates from the contents of a combobox only.
There is a field on the form that has been prepopulated with a list that I
would like to use in a combobox along with what a user might type in, only
problem is that there may be multiple entries of the same item,
how do you get it down to only one item
example;
if the field contains
banana
apple
peach
peach

how would you populate a combobox to be
apple
banana
peach

Thanks
David

 

[David Whitaker]

fiqured it out

use the control source of the existing table
then make a new query and set the comboboxes rowsource to the new query