Database Programming

[espylacopa]

Ok. Here is my problem.

I need to have the user perform a search (eg. last name).
Let's say they type in smith as the last name. I got this part ok, what I want is if there are 5 smiths, they can choose one and go to the customer properties to change information.

So my question is, what is the best control to use to retrieve search data and allow the user to click on the desired result and have the customer properties open with all the customer information?

[RhinoBull]

There aint any controls for that purpose - you'd have to code it yourslef.
General idea is as follows:
- open connection
- construct sql statement such "Select * From Customers Where Last_Name Like 'Smit%'"
- open recordset based on your sql
- populate all necessary controls (grid, textboxes, etc ...)

[espylacopa]

what i am getting at is, after running a query and populating the datagrid with the results, how do i populate text boxes based on what result was clicked on from the datagrid.

[RhinoBull]

Which datagrid are you using? There are two: one is Data Bound Grid (DBGrid) and second is Data Grid (DataGrid).

[espylacopa]

DataGrid

[RhinoBull]

Oh, ok. In that case all you'll need to do (after search is completed) is something similar to the following:

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
    Text1.Text = Adodc1.Recordset!ID
End Sub