Bound ComboBox Data Error
I have written a program that binds controls on a form to fields of a table in a Microsoft Access database. One of the controls on the form is a combo box that contains three names in its Items property. I use BindingSource filtering to change from one record to another. When I change from one record to another, if the new record has nothing in the combo box control then the data that had been in the combo box for the previous record is displayed for the new record and appears as though it was either selected or had been stored in the database. If a record already has legitimate data for the combo box it displays properly and there is no problem with data from the previous record being copied, it only happens when a record without any combo box data is displayed.
I have noticed that the problem can be prevented by adding an empty line to the beginning of the Items property, but I do not like how this looks. I am hoping that someone knows how to prevent the combo box from retaining data when it should be blank.
Below is the data setup the binding source and the combo box binding:
.BindingSource1 = New BindingSource With .BindingSource1 .DataSource = Me.aDataSet .DataMember = "Data" .Sort = "ID" .MoveLast() .MoveFirst() End With Me.ComboBox1.DataBindings.Add("text", BindingSource1, "LName", False, DataSourceUpdateMode.OnValidation)
