combo box duplicates

[j3andc]

I am using a combo box to populate data. I have 6 records currently in the table and 3 of them are the same. The combo box is listing all 3 when I am trying to select a new one. I want the list to only show the duplicates one time. How do I do this?

Jim

 

[j3andc]

Actually, I have now got the original one (Me.MyCombo.Requery) to work. I found a line in the properties box that tells the field what to do On Exit. I picked requery and it worked. I am trying to apply it to a second combo box and so far I have not been successful.