Hi guys

In my application I have some comboboxes (three to be exact) who all share the same datasource. The problem is the following: when the user clicks one of the comboboxes and selects an item, then in the other comboxes the same item also becomes selected. How can I avoid this?

I wrote the following code:

VB Code:
  1. 'creation of the dataset

  2.  
  3.  Dim SQLDossier As String

  4.  
  5.         SQLDossier = "SELECT * FROM basisgegevens"

  6.         ConnectionDossier.Open()

  7.         DADossier = New OleDbDataAdapter(SQLDossier, ConnectionDossier)

  8.         DADossier.Fill(DSDossier, "tblDossier")

  9.         ConnectionDossier.Close()

  10.  
  11. 'filling of the comboboxes

  12. CmbDossier1.DataSource = Me.DSDossier

  13.         CmbDossier1.DisplayMember = "tblDossier.DOSSNR"

  14. CmbDossier2.DataSource = Me.DSDossier

  15.         CmbDossier2.DisplayMember = "tblDossier.DOSSNR"

  16. CmbDossier3.DataSource = Me.DSDossier

  17.         CmbDossier3.DisplayMember = "tblDossier.DOSSNR"

I already tried to clear the databindings of the combobox control but that doesn't works correct.

How should I do this?

Any ideas?

thnax