How to open page2 of a tab control with the records created on page1

[mdavid]

Hi, I have 2 pages in a tabControl - Page1 and Page2.
Each page consists of a form with a subform.
I have a button on Page1 with onClick code that updates tables that appear in the forms on Page2, after updating the tables I want to automatically open Page2 showing the records that I updated on Page1.
I tried DoCmd.OpenForm but that opens a separate form - without the records. How would I open Page2 with the updated records?



Thanks for any help
David

[June7]

Requery the form on Page2 then set focus to Page2.

[mdavid]

Hi, Thanks for this.
I added:

       Forms![MempBercMainFrm2].Form![FloraPComplaintWithPreparations].[Form].[RecordSource] = _
                                                 "SELECT * FROM FPComplaintHdr WHERE FdComplaintID = " & newHdrID & " "
       Forms![MempBercMainFrm2].Form![FloraPComplaintWithPreparations].Requery
       Forms![MempBercMainFrm2].[Form]![TabCtl0].Pages(1).SetFocus

On the code in red I get:

Run-time Error '424' Object Required

[June7]

This code is behind the main form?

You want to set RecordSource of a subsubform?

I always give subform container control a name different from the object it holds, like ctrFlora.

Me.ctrFlora.Form.ctrSomething.Form.RecordSource = "SELECT * FROM FPComplaintHdr WHERE FdComplaintID = " & newHdrID & ";"

However, I don't normally set RecordSource if I can help it, I just set Filter and FilterOn properties.