I have a main form (Form A) with a subform embedded (Form B)
When I click a button to open a second form (Form C), gets embedded
Form C has a double-click event to open the specific form to the record:
DoCmd.OpenForm "FormD", , , "RequestID=" & RequestID, , acDialog
How can I translate the DoCmd.OpenForm code above to behave the same way as Form C?
I tried:
but I got Compile error: Method or data member not found
I would prefer for it to open over the embedded forms, how can I reference it with a criteria? Is it possible?
When I click a button to open a second form (Form C), gets embedded
Code:
Me.FormB.SourceObject = "FormC" ' - no problems there
Form C has a double-click event to open the specific form to the record:
DoCmd.OpenForm "FormD", , , "RequestID=" & RequestID, , acDialog
How can I translate the DoCmd.OpenForm code above to behave the same way as Form C?
I tried:
Code:
Me.FormC.SourceObject = "FormD" 'AND
Me.FormB.SourceObject = "FormD"
but I got Compile error: Method or data member not found
I would prefer for it to open over the embedded forms, how can I reference it with a criteria? Is it possible?