Hello:

I have a datacombo3 that I can't clear the drop down list until I exit and reload the form.

Set DataCombo3.DataSource = Nothing
Set DataCombo3.RowSource = Nothing

It sill show the list from the last ado connection. Even after setting the Datasource & Rowsource to nothing and rebinding with the below statement.


This is a Blank DataBase
'*****************************************
Dim sql As String
sql = "Select * from Brand order by brand"

Adodc3.CommandType = adCmdText
Adodc3.RecordSource = sql
Adodc3.Refresh

Set DataCombo3.DataSource = Adodc3
Set DataCombo3.RowSource = Adodc3.Recordset

DataCombo3.BoundColumn = "ID"
DataCombo3.ListField = "Brand"

DataCombo3.Text = DataCombo3.Text
DataCombo3.BoundText = DataCombo3.BoundText 'A trick to help