Combobox & Distinct

[Irene]

I've created a combobox that takes data from a table. And
I used the Distinct function to filter out the repeated
values in the table. However,when I click on my combobox
and select a value, let's say 4000, the number that shows
after I click on the value is 20; 20 is the very first
number that appears in line in the combobox. How do I
correct this?

Irene

 

[John Viescas]

Irene-

What's the Row Source of the combo box (the SQL), and what is your setting
for the Bound Column property?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)