ADO data control and Datagrid (oledb)

[sultan]

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 ?

[sultan]

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.