topic Clearing a combobox of Previous Selections! in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372024#M9764 <HTML><HEAD></HEAD><BODY><SPAN>I am loading comboboxes upon selection of previous comboboxes selections. I am having trouble clearing the box so that only the AddItems will show. For Example: Depending on what year they select only certain city names should show in the last combobox. But the combobox instead of clearing just keeps adding the city names. I have .Clear programmed but it's not working.&nbsp; I've included my code below: </SPAN><BR /><BR /><PRE class="plain" name="code">Private Sub UserForm_Initialize()&nbsp; &nbsp;&nbsp;&nbsp; Dim WorkDB As DAO.Database &nbsp;&nbsp;&nbsp; Dim workRecSetA As DAO.RecordSet &nbsp;&nbsp;&nbsp; Dim workRecSetB As DAO.RecordSet &nbsp;&nbsp;&nbsp; Dim x As Integer &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Set WorkDB = DBEngine.OpenDatabase("K:\TASS\2 - GEO-DATA PROCESSING SUPPORT\MICHELLE'S WORK_ENTER NOT!!\Work Folder\Map Automation Project\Access Tables\Map_Automation.mdb") &nbsp;&nbsp;&nbsp; Set workRecSetA = WorkDB.OpenRecordset(Name:="select * from Districts order by District_Name", Type:=dbOpenDynaset) &nbsp;&nbsp;&nbsp; Do Until workRecSetA.EOF &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem workRecSetA("District_Name") &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workRecSetA.MoveNext &nbsp;&nbsp;&nbsp; Loop &nbsp;&nbsp;&nbsp; Set workRecSetB = WorkDB.OpenRecordset(Name:="select * from Stations order by Station_Name", Type:=dbOpenDynaset) &nbsp;&nbsp;&nbsp; Do Until workRecSetB.EOF &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboStations.AddItem workRecSetB("Station_Name") &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workRecSetB.MoveNext &nbsp;&nbsp;&nbsp; Loop &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; For x = 2010 To 2015 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem x &nbsp;&nbsp;&nbsp; Next &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub&nbsp; Private Sub cmdCancel_Click()&nbsp; &nbsp;&nbsp;&nbsp; frmMapSetUp.Hide &nbsp;&nbsp;&nbsp;&nbsp; End Sub Private Sub cboStations_Change() &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If cboStations.Text = "Urban" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2010" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2011" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2012" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; End If &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub Private Sub cboYear_Change()&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; If cboYear.Text = "2010" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Abilene" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Amarillo" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Austin" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "San_Antonio" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Waco" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Wichita_Falls" &nbsp;&nbsp;&nbsp; ElseIf cboYear.Text = "2011" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Beaumont" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Houston" &nbsp;&nbsp;&nbsp; ElseIf cboYear.Text = "2012" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Brownwood" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Bryan" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Childress" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Corpus_Christi" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "El_Paso" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Lubbock" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Odessa" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Yoakum" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; End If &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub</PRE></BODY></HTML> Wed, 13 Mar 2013 12:36:33 GMT MichelleCouden1 2013-03-13T12:36:33Z Clearing a combobox of Previous Selections! https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372024#M9764 <HTML><HEAD></HEAD><BODY><SPAN>I am loading comboboxes upon selection of previous comboboxes selections. I am having trouble clearing the box so that only the AddItems will show. For Example: Depending on what year they select only certain city names should show in the last combobox. But the combobox instead of clearing just keeps adding the city names. I have .Clear programmed but it's not working.&nbsp; I've included my code below: </SPAN><BR /><BR /><PRE class="plain" name="code">Private Sub UserForm_Initialize()&nbsp; &nbsp;&nbsp;&nbsp; Dim WorkDB As DAO.Database &nbsp;&nbsp;&nbsp; Dim workRecSetA As DAO.RecordSet &nbsp;&nbsp;&nbsp; Dim workRecSetB As DAO.RecordSet &nbsp;&nbsp;&nbsp; Dim x As Integer &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Set WorkDB = DBEngine.OpenDatabase("K:\TASS\2 - GEO-DATA PROCESSING SUPPORT\MICHELLE'S WORK_ENTER NOT!!\Work Folder\Map Automation Project\Access Tables\Map_Automation.mdb") &nbsp;&nbsp;&nbsp; Set workRecSetA = WorkDB.OpenRecordset(Name:="select * from Districts order by District_Name", Type:=dbOpenDynaset) &nbsp;&nbsp;&nbsp; Do Until workRecSetA.EOF &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem workRecSetA("District_Name") &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workRecSetA.MoveNext &nbsp;&nbsp;&nbsp; Loop &nbsp;&nbsp;&nbsp; Set workRecSetB = WorkDB.OpenRecordset(Name:="select * from Stations order by Station_Name", Type:=dbOpenDynaset) &nbsp;&nbsp;&nbsp; Do Until workRecSetB.EOF &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboStations.AddItem workRecSetB("Station_Name") &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workRecSetB.MoveNext &nbsp;&nbsp;&nbsp; Loop &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; For x = 2010 To 2015 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem x &nbsp;&nbsp;&nbsp; Next &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub&nbsp; Private Sub cmdCancel_Click()&nbsp; &nbsp;&nbsp;&nbsp; frmMapSetUp.Hide &nbsp;&nbsp;&nbsp;&nbsp; End Sub Private Sub cboStations_Change() &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If cboStations.Text = "Urban" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2010" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2011" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboYear.AddItem "2012" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; End If &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub Private Sub cboYear_Change()&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; If cboYear.Text = "2010" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Abilene" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Amarillo" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Austin" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "San_Antonio" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Waco" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Wichita_Falls" &nbsp;&nbsp;&nbsp; ElseIf cboYear.Text = "2011" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Beaumont" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Houston" &nbsp;&nbsp;&nbsp; ElseIf cboYear.Text = "2012" Then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.Clear &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Brownwood" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Bryan" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Childress" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Corpus_Christi" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "El_Paso" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Lubbock" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Odessa" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cboDistrict.AddItem "Yoakum" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; End If &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Sub</PRE></BODY></HTML> Wed, 13 Mar 2013 12:36:33 GMT https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372024#M9764 MichelleCouden1 2013-03-13T12:36:33Z Re: Clearing a combobox of Previous Selections! VBA(ArcOBjects) 6.0 https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372025#M9765 <HTML><HEAD></HEAD><BODY><SPAN>Forgot to tell you all this program is in VBA (ArcObjects) 6.0!!</SPAN></BODY></HTML> Wed, 13 Mar 2013 12:37:29 GMT https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372025#M9765 MichelleCouden1 2013-03-13T12:37:29Z Re: Clearing a combobox of Previous Selections! https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372026#M9766 <HTML><HEAD></HEAD><BODY><SPAN>Answered!!!</SPAN></BODY></HTML> Wed, 13 Mar 2013 12:44:05 GMT https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372026#M9766 MichelleCouden1 2013-03-13T12:44:05Z Re: Clearing a combobox of Previous Selections! https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372027#M9767 <HTML><HEAD></HEAD><BODY><SPAN>Please post the answer if you are going to mark a thread as answered. That way, if someone has a similar question, they can see your solution.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Wed, 13 Mar 2013 15:17:32 GMT https://community.esri.com/t5/arcobjects-sdk-questions/clearing-a-combobox-of-previous-selections/m-p/372027#M9767 JasonPike 2013-03-13T15:17:32Z