Refreshing a ComboBox

• • Reply

  15 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago
  Hello,
  
  I have a ComboBox and any time one is selected I have a question that if another one should be selected
  then after the ComboBox should have one selection less....! I implemented the
  
  
  MyCommand = "SELECT Table_Cartes.Carte_Nom FROM Table_Cartes " & _
                             "WHERE Table_Cartes.Carte_Nom NOT IN (SELECT " & _
                             "Table_Employés_Cartes.Employés_Cartes_Nom FROM " & _
                             "Table_Employés_Cartes WHERE " & _
                             "Table_Employés_Cartes.Employés_Cartes_ID = " & " '" & TextBoxMatricule.Text & "')"
  
  But, it still shows me the whole list....I think I should clean or clear the ComboBox before calling the query.
  
  My question is I have no idea how to clear or clean the ComboBox....I can't find the method on books or web
  
  Thank you
  
  
  
  
  Report abuse
• • Reply

  15 years ago

  by Rollershade

  Colin Harman MACITP

  West Sussex, England, Australia

  Joined 19 years ago

  in .net u will find that most/all controls will have an Items object from which all methods below are the same across controls, so the same for a combobox as is the same for a list box etc, they all have the same member .Clear() .ADD() .Count() etc etc
  

  
  to clear your box do :
  

  
  comboBox1.Items.Clear()

  Report abuse
• • Reply

  15 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago

  Thank you Rollershade!   I used that....but is my mistake...I did not explain myself correctly....!
  

  
  I used as a fill method the:
  

  
  daCombo.Fill(dsCombo, "Cartes")
  

  
  With ComboBox
         .DataSource =  dsCombo.Tables("Cartes")
         .DataMember = "CarteNom"
         .valueMember = "CarteNom"
  End With          
  

  
  So, when I want to select another one from the list, I confirmed with an ADD button and it is there where I want that list to decrease by the one selected.....I used the ComboBox.Items.clear() and I got an error because the .DataSource is used to fill the ComboBox.....!
  

  
  Any idea?                            

  Report abuse