New Record Default

[RaunLGoode]

Is there a way to configure a form where it defaults to a “new record” when the form is opened?
Would this be a major design mistake?

 

[Rob.Mills]

In the On Open event of the form (or even on load) use a Docmd.GoToRecord acNew

Or if you want it to be strictly a data entry form you can set the form's property to data entry or you can open the form in Add mode.

 

[RaunLGoode]

Thanks for your reply,
OK, It's pretty obvious I am a rookie, could you explain opening in the Add Mode in a bit more detail?

 

[Rob.Mills]

Thanks for your reply,
OK, It's pretty obvious I am a rookie, could you explain opening in the Add Mode in a bit more detail?

lol. Been there.

Well you can do this with either macros or VBA. Add mode simply means that the form is opened with the recordsource you declared but without any of the existing records. So with this mode, when you open it you won't be able to navigate between records until you add some. With the other method of going to a new record the form is opened with all existing records in the recordsource but it moves to a new record. Which one to use just depends on your situation.

If you look up gotorecord in the help menu you can get some more details on all of this.

 

[AN60]

If you mean you want the form to open with the fields blank ready to enter data you can set this by going to the particular form's properties and clicking on the Data tab then set Allow Additions to Yes.