Excel 2007 Sheet ADODB.RecordSet become Nothing when assign to pop up form (VB 6 macro cod

Hi,

Need advice with this problem "Excel 2007 Sheet ADODB.RecordSet become Nothing when assign to pop up form (VB 6 macro code)"


At Sheet i can connect to MySQL, return recordset from MySQL and display record row by row at the Sheet, no issue on this.

What i try to do is
When i double click the row record, a new form will pop up and display the clicked record to the form.

But the recordset i "pass" or assign from Sheet to form become Nothing.


Below is some of the code

At mySheet--------------------------------------------------

Please Login or Register  to view this content.

At myForm------------------------------------------------

Please Login or Register  to view this content.

Why sheet_rs become Nothing ? How to make it work ?


regards

johnnighter