Hello everyone!
I am brand spanking new and really in a bind. Can any one help me solve some problems I'm having with (VB 6) Data grids?

Here is what I am trying to do:
I have a DG (DG1)with several Fields, When a user clicks on a row, I want to take data out of a cell (or the field in the record set populating that cell) in that row (not neccessarly the one the user clicked on) and use it to change the SQL query of an ADODC "controlling" a different data grid (DG2). The problem I am having is getting to the fields in the recordset of DG1 .


PS: can I do this with a bookmark? how do bookmarks work? I can't find the syntax