
ADO DataCombo list field has duplicate entries
I have a drop-down DataCombo control that is connected to a customer
database. The list field text is the customer last name and bound
column is the customer ID. There are, of course, dupplicate last names
in the list (i.e. Smith Bob, Smith Bill, Smith Tom etc.). When I use
the mouse or keyboard arrow buttons to scroll through the duplicate
last names, the data "freezes" on the first occurrence of the duplicate
name and does not change until a different name is encountered (i.e.
Joe Stein). Here is the code I am currently using for the
DbCombo_Change event:
Private Sub FindArtistByID()
With adoArtists.Recordset
.MoveFirst
Do Until !art_id = dbcArtistName.cus_id
.MoveNext
Loop
End With
End Sub
Any help will be greatly appreciated.
The Maestro
Sent via Deja.com
http://www.*-*-*.com/