Form to add a new record...

[grande]

This is probably really easy, but I couldn't find it in the forums.

I click a button to open a bound form. How do I get the form to open to a new record?

-------------------------
Just call me Captain Awesome.

 

[RoyVidar]

Either try setting the [tt].DataEntry[/tt] property of the form to yes, use [tt]DoCmd.GotoRecord,,acNewRec[/tt] in some relevant event (form load), or perhaps use acFormAdd as the [tt]DataMode[/tt] arguement of the [tt]DoCmd.OpenForm[/tt] method.

Roy-Vidar

 

[vpelleri]

Add the line below to the Open event of your form as code.

DoCmd.GoToRecord acActiveDataObject, "YourFormName", acNewRec