Remove duplicate entry in combobox

Similar Threads:

1.combobox - removing duplicates

Is there anyway to remove showing duplicate records ina  subform linked to a
query

The query just shows NAMES in AZ order from the table, but I dont want the
combo to show duplicate names?

Thanks.

Neil

2.Removing choices from combobox query but stilling showing for older entries

3.Duplicate field entries with combobox

I have a form which employs a couple of combo boxes that allow me to
enter Vendor and Model information into a table.  The combo boxes
employ a SELECT DISTINCT query to populate the lists.  I am now trying
to add a warning message if a value that is not in the list is
entered.

Private Sub cboUnbound_NotInList(NewData As String, Response As
Integer)
  Dim cnn As New ADODB.Connection
  Dim strSQL As String
  Dim bytResponse As Byte
  Set cnn = CurrentProject.Connection
  bytResponse = MsgBox("Do you want to add this new item " _
   & "to the list?", vbYesNo, "New Item Detected")
  If bytResponse = vbYes Then
    strSQL = "INSERT INTO Colors(Colors) VALUES('" _
     & NewData & "')"
    Debug.Print strSQL
    cnn.Execute strSQL
    Response = acDataErrAdded
  ElseIf bytResponse = vbNo Then
    Response = acDataErrContinue
    Me!cboUnbound.Undo
  End If
End Sub

The problem is that when I reply 'yes' to the msgbox I get an extra
entry in the destination table with just the one field bound to the
combobox and the new value.  So I get one complete record and another
record with a value in only one field.  What am I doing wrong.

4.How can I remove duplicate Holiday entries?

I have accidentally added duplicate holiday entries on my calender in 
Outlook.  How can I remove them?

5.Letter Merge / Removing Duplicate Entries

 
How do I remove "duplicate" records prior to the merge
process?

For instance, record 1 Bill Smith / 120 Main Street
              record 2 Jill Smith / 120 Main Street
              record 3 Ron Jackson / 500 Elm Street

I would like only two labels:
(1) The Smith Family / 120 Main Street
(2) The Jackson Family / 500 Elm Street

How can I intercept the input merge file and remove
the duplicate (2nd) record?  Is there an option within
the merge process?

My version of Word is Word 2000.

Thank You.

6. Removing or hiding Items from a Combo Box that have been selected--preventing duplicate entries

7. Can we remove duplicate entries in MS Access

8. Duplicate Query - How to Remove Duplicates from Original Table