Combo Box

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

Guest

I have a LookUp table in a Form. There are repeats of names in the table.
How can I get only one name of each to appear in my Combo list?
Thanks!
 
Sam --

The answer to your questions depends on the way in which the Combo box is
populated. I assume that it retrieves information from a table with a query.
If this is the case, try using SELECT DISTINCT instead of SELECT to retrieve
the information to go into the Combo box.

HTH!
 
Back
Top