in the following code I want to fill MSFlexGrid1 by the recordset (RS) data but it gives me error.
Private Sub Form_Load()
RS.open "Select * from Table1"
Me.MSHFlexGrid1.DataSource = RS
Feel free to suggest and ammend this code to fill MSFlexGrid1 by the recordset data using SQL statements.
Note: I have already defined and opened the RS and ADODB connection in another lines in my project.