Mis-Behaving Combo Box

[RHubbard]

Here's an odd problem.

I have an unbound combo box on a form that is used to look up names of organizations. It works exactly as it is supposed to except for this anomaly-- Anytime the user types in "YWCA" to begin the search process, YWCA appears 2 times in the box, one above the other! It looks like this:

YWCA
YWCA

I tried taking all the various records that begin with YWCA out of the underlying table and re-entering them, but I get the same behavior JUST for that particular name. I also tried re-creating the unbound combo box, but that didn't solve the problem either.

This is driving me batty. Can anyone suggest a solution?


Rick

 

[Alexandre]

It seems that either you based your combo on a table where organizations names are not uniques (not a top-hierarchy lookup table of organizations but some table on the many side of a relationship). In this case, use a top-hierarchy table instead or use a SELECT DISTINCT statement. Or you based it on a query including a join to a table that can have many records for each organization. In the latter case, though they do not necessarily display if you didn't include them in the SELECT statement, they duplicate records on the One side unless you use a SELECT DISTINCTROW statement.