Error trying to set Datasource property of DBGrid control to SQL selected recordset
Hi I am not using a data control object I am using SQL only. I am trying to set a DBGrid control to a recordset that was set using this statement in a Sub procedure in a standard module
Set grstCurrentRS = gdbCurrent.OpenRecordset("Select * from tblOrderMaster where fldCustomerID like " & "'*" & glngCustomerID & "*'")
that statement works fine. I have set textbox's using variables set from that grstCurrentRS recordset. But now Im trying to set a DBGrid control to that recordset using:
Set dbgOrderMaster.DataSource = MR_OS.grstCurrentRS
In the Form load event of the form that the DBGrid control dbgOrderMaster is in, and I get this error
run time error 430:
Class does not suport Automation or does not support expaected interface
I tried setting the datasource property of the DBGrid control by typing the recordset object MR_OS.grstCurrentRS into the Datasource property in the property window of the DBGrid control, and I dont get any error's but it does not load the recordset into the DBGrid its just blank.
How do I set a DBGrid control to a recordset without a data control object only sql
help plz
[Edited by VB_Sponge on 04-22-2000 at 08:27 PM]
