I have a form called "form3" with tabbed form "Form1" with tabbed sub form objects within the "form1". All i am trying to do is, create a lookup form called "Form2" (click advanced option) and select the record in lookup form and return it to main form. See attach sample DB.
If i open form1, it works no problem.
DoCmd.OpenForm "Form1"
Set rst = Forms!Form1.Recordset.Clone
rst.FindFirst "[Inven ID] = " & Me.SearchList
Forms!Form1.Bookmark = rst.Bookmark
But if i open "form3" then it gives me an error message "Object doesnot support this property or method".
DoCmd.OpenForm "Form3"
Set rst = Forms!Form3!Form1.Recordset.Clone
rst.FindFirst "[Inven ID] = " & Me.SearchList
Forms!Form3!Form1.Bookmark = rst.Bookmark

If i open form1, it works no problem.
DoCmd.OpenForm "Form1"
Set rst = Forms!Form1.Recordset.Clone
rst.FindFirst "[Inven ID] = " & Me.SearchList
Forms!Form1.Bookmark = rst.Bookmark
But if i open "form3" then it gives me an error message "Object doesnot support this property or method".
DoCmd.OpenForm "Form3"
Set rst = Forms!Form3!Form1.Recordset.Clone
rst.FindFirst "[Inven ID] = " & Me.SearchList
Forms!Form3!Form1.Bookmark = rst.Bookmark

Attachments
Last edited: