Open Form on New Record

[carbo20]

new record on the form ?

hi.
i created a form.
but every time that i run the form i get record number 1.
what should i do to make theform open in a new record?
thank you.
Nir

 

[Mile-O]

Two ways:


In the form's Load event:

DoCmd.GotoRecord , , acNewRec

Or, when opening the form in code:

DoCmd.OpenForm "MyName", , , , acFormAdd

 

[ehdoh]

I am dealing with the same issue, but am trying to use a command button on a subform to open a new record for the form. Can I use the code Mile-o-Phile suggested? Do I need to set the focus to the form first, before inserting DoCmd.OpenForm "MyName", , , , acFormAdd ??

Cheers,
e.