ADO recordset Error
Posted on 2014-04-07
I have combo box “cbo.CodeID” on the main form named frm_Main.
On mani form I have sub form named “frm_SubForm”
I pulled ADO recordset "rsSub" from table without error,now I want next:
On after update event in combo box I want to refresh my subform “ frm_subForm” with ADO recordset “rsSub” as subform recordset.
I have this code in comb box after update event:
Set Froms!frm_Main!frm_subForm.Form.Recordset = rsSub
I am getting error
Run-time error '7965'
the object you entered is not a valid recordset property