Display selected record from DataGrid in text boxes

[jbradley]

I have a datagrid which I populate from an open ADO recordset built from a query against a SQL table. I would like to be able to click on a record in the datagrid and have the fields populate a set of text boxes where the user could edit the data and update the table. Could someone suggest how to go about getting the selected data in the datagrid into the text boxes and then back to the table?

Thanks...

 

[zemp]

Why not allow the user to make updates directly on the grid. Set the grid's .AllowUpdate property to true. Thanks and Good Luck!

zemp

 

[Deke2]

Allowing the user edit the datagrid can be a dangerous thing, many users don't know how to operate the datagrid in a add,edit,delete mode you will find that records are added that are blank or edited mistakenly.

Use the ID field from the datagrid in the WHERE clause in another recordset, then populate your text boxes with that.

Do your editing on the text boxes and save then refresh your recordset that the datagrid is bound to.

It's alittle bit more involved then this but this is the main idea.

Deke2