I browsed through the forums and did not see a topic like this, if I missed it please point it out to me. Here is my situation. I have a form with several textboxes that reflect the columns of my SQL database. I also have a search function which opens a second form which has a datagridview that displays the query results. The first column of this DGV is the Primary key AND the record number found on the bindingnavigator from form one. What I'd would like to do is when a row is clicked in the DGV, is to navigate to the appropriate record on form1. Would anyone have an example on how to do this?

Thank you in advance.