open form on "new record" screen (1 Viewer)

[Funkyaccess]

Hi,

I have a form with tabs and each tab contains a subform. How can I set this subform to start with a new record?

 

[John Big Booty]

Check out DoCmd.GoToRecord you want acNewRec.

Given that you are dealing with a SubForm this link will help you get the reference correct.

 

[boblarson]

You can also use this:

Me.YourSubformControlNameHere.Form.Recordset.AddNew

Where YourSubformControlName is the name of the subform control on the main form which houses the subform.

See here for which name you use:

 

[Funkyaccess]

thanks for both the options. wheres the best place to initialise the docmd/.addnew to goto the new record?

 

[boblarson]

thanks for both the options. wheres the best place to initialise the docmd/.addnew to goto the new record?

On Load event of the subform.

So if you do that, then you will not want to use my code, but instead just use JBB's, or use

If Not Me.NewRecord Then
   DoCmd.RunCommand acCmdRecordsGoToNew
End If

 

[Funkyaccess]

Thanks both of you. I'm now getting the effect I was after.