Dups in ComboBox

[Guest]

I get duplicate names in my query based combo box. I have tried setting the
Query properties of the Unique Values and Unique Records to Yes, (one at a
time), but none of this stops the duplicate names in the combo box. Any other
suggestions ?

 

[Douglas J. Steele]

Unique Values and Unique Records are sensitive to all of the fields.

With Unique Records, two rows are only considered to be alike if the values
for all fields are alike.

With Unique Values, two rows are only considered to be alike if the values
for the selected fields are alike.

I'm guessing you've got too many fields selected in your query. Reduce to
only the required fields, and use Unique Values.

 

[Guest]

Ok, I understand the Unique Recs and Unique Values now. I guess I cannot rid
the dups in my combo box because in my query the only dup info are the fields
that are the person's First, Last Names and Middle initals. The rest of the
fields included in my query are unique. Thank you for trying. Unless someone
has another idea for me.

 

[Guest]

Hey, I changed the Unique Value on the actual combo box instead of the query
and all the duplicate names disappeared. Thank you.

 

[Guest]

How do you change The unique value on an actual combox?

 

[Van T. Dinh]

There is no such property on the ComboBox AFAIK. I think "Tall Mary" might
have meant changing the SQL String being used as the RowSource for the
ComboBox.