I know how to bind ADODB recordset to MainForm, how about the SubForm ? Can anyone suggest as I have worked out the below through Main form concept, however, it won't work for SubForm. Codes that I have tried it out are :-
1) Forms![MainForm]![SubForm].Form.Recordset = rsTemp
2) Forms.MainForm.SubForm.Recordset = rsTemp
3) Me!SubForm.Recordset = rsTemp
4) Me!Parent.SubForm.Recordset = rsTemp
5) Me.Parent!SubForm.Recordset = rsTemp
All the above produce error.
1) Forms![MainForm]![SubForm].Form.Recordset = rsTemp
2) Forms.MainForm.SubForm.Recordset = rsTemp
3) Me!SubForm.Recordset = rsTemp
4) Me!Parent.SubForm.Recordset = rsTemp
5) Me.Parent!SubForm.Recordset = rsTemp
All the above produce error.