How do I keep the same item from showing up several times in a dr.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Access form, I have a drop down (combo box) with names. Every time I
enter a name, it shows up multiple times. How do I limit the same name from
showing up several times in the combo box?
 
Rosie said:
In an Access form, I have a drop down (combo box) with names. Every
time I enter a name, it shows up multiple times. How do I limit the
same name from showing up several times in the combo box?
Click to expand...

Is your combo's rowsource the same table your form is bound to, or a
query of that table? If so, you probably want to add the DISTINCT
keyword to the query's SQL, or -- the equivalent -- setting the query's
Unique Values property.
 
I think this can be handled using the word "DISTINCT" in the Rowsource of
the Combo Box.

Put something like this in there:

SELECT DISTINCT [FieldName] FROM [TableName];

That should take care of any duplications.

T
 
Back
Top