I am trying to get the recordset of a subform (SubForm) from a module. This subform is inside a tab (the main form (MainForm) contains a tab control). What am I missing here? Thanks.
'The last statement of code will not work.
'The below code is execute from a module
Dim rs As DAO.Recordset
DoCmd.OpenForm "frmMainForm", acNormal
Forms!frmMainForm!frmSubForm.SetFocus 'this works
Set rs = Forms!frmMainForm!frmSubForm.Recordset.Clone 'this will not work