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--------------------------------------------------
At myForm------------------------------------------------
Why sheet_rs become Nothing ? How to make it work ?
regards
johnnighter
Bookmarks