Opening a Form to a new Record

[Mike555]

By default, when opening an Access form the first record entered into the form is displayed. How can a form be setup to open to a new record, instead of displaying existing records first?

Thanks.

 

[930driver]

This works in A2K and I believe in A97, don't know about others.

DoCmd.OpenForm "frmFormName", , , , acFormAdd "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[Mike555]

That's good cause I'm using A2K.

Can this statement be created with an On Open Event in the properties of the Form? If so, what would the code look like? (I'm horrible with VBA.) Thanks.

 

[930driver]

If you want a particular form to open in Add mode regardless of how it is opened set it's Data Entry property to Yes. This is found on the properties sheet on the Data tab.

"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"