Tabbed form and subform objects - please help

NPUser

Registered User.
Local time
Yesterday, 19:53
Joined
Jul 25, 2004
Messages
55
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

:confused:
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom