Open Form with New record

[Dominate007]

Im compiling a database for my company. My boss wanted the database to open with a "Welcome form" which ive done, on that form there are buttons that link to the other forms in the database. when i click on the button it goes to the form but open on the first record, i want it to open on a new record. i went to the microsoft website and found this
Sub ShowNewRecord()
DoCmd.OpenForm "Employees", acNormal
DoCmd.GoToRecord , , acNewRec
End Sub

That didnt help at all because ive never used visual basic before, but it is now part of my job description!!!! could someone PLEASE help me so that when i click on the button it opens the form with a new record.
The two forms that need to be linked are "Axiom Repair Form" and "Third Party Repair Form"

Thanks a million

 

[lupins46]

The simplest way to do this without using VBA is to create a macro to open your form at a new record. Use Datamode 'Add' to get to a new record.
Then use the button wizard to add a button to your menu form that runs the macro.

 

[Dominate007]

That sounds like it could help, but i cant seem to see where to add a new macro, only where to run an already configured macro.

 

[lupins46]

In the macros tab in the database window, click 'New'.

 

[MCesic]

to do it without macro
just put the line

DoCmd.GoToRecord , , acNewRec

in the OnLoad event of the form as VBA code..

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

greets,
Marko 9A6NCM

 

[Dominate007]

Thanks guys, i placed the code into the appropreate line and it works!