Coding the ado to a textbox!

Ok I simply now need to assign these textboxes to a new ado when a datagrid gets focus IN CODE. I cannot get the syntax right, anyone have a example.

IE: Datagrid2_gotfocus
txt1.text = (adodc3 and hooks to the CusName Datafield)

Whats the Syntax??? Danke!

Are you wanting to access a recordset that you already have open?

YES

txt.text = rs.Fields("CusName").Value


rs is the name of the recordset that you have open.

Also check out the ADO data control in the MSDN. Under the ADO data control there is a recordset property. This may be what you were asking for. Sorry for taking you the long route if it was.