-
Can anyone help me with the followings:
I am using ADO control and a Datagrid (OLEDB) grid in my project in VB6.
I need to use a dropdown combo to display the customerid field. Once the user selects a particular customerid or types
one in then I need to show the results in the grid.
I can populate the combobox to display the list of customerid ie all records. But i cant get the grid to do find and go to that
customerid which user selects in the combobox.
How can i possibly achieve this ?
-
Just to share this with all who might be interested, Serge has already answered my question and its as follows
This example uses Northwind database.Put this on Combo1_Click event:
code:
Private Sub Combo1_Click()
Adodc1.Recordset.Find ("CustomerID='" & Combo1.List(Combo1.ListIndex) & "'")
End Sub
If CustomerID in your database is a numberic field then use this:
Adodc1.Recordset.Find ("CustomerID=" & Combo1.List(Combo1.ListIndex) & "")
Since you have the DatGrid bounded to the AdoDC, it will jump to the record you select in the Combobox.