Sharing an ADO connection

I have a form with a patient record on it. I also have a button that the user can click on and bring up a seperate form with a search box and a data grid. When the user clicks on a result in the data grid I want the information to be presented on the main patient form. Any help here. I am sure it is simple and I am over-looking something.


================================================
Noble D. Bell
Owner
www.noblesoftware.com

When you say click on a result in the datagrid, is this another patients record?. Also are you using code for the recordsets or the ADO data controls ?

Work is necessary for man. Man invented the alarm clock.