Change SubForm record to NEW Record

[ted.martin]

I have a Main form with a Sub-Form in single form view.

The subform is showing the last record.

I have a button on the Main Form which when pressed I want to change the Sub Form to New Record.

The Button code below errors because I have the wrong of Data Type for one of the arguments.

DoCmd.GoToRecord acDataForm, [Forms]![F-Patients].[SF-Rx Final], acNewRec

Any help would as always be appreciated. Thanks


NO NEED - FOUND IT

        Me.SF_Rx_Final.SetFocus
        DoCmd.RunCommand acCmdRecordsGoToNew

 

[MStef]

You don't need a button.
There are a NAVIGATION BUTTONS, (one for main form, and
one for subform).