Open a form and automatically start with a blank/new record 1

[Cero21]

The users of my database are going to edit/add/delete records in the database using forms. The problem is when they open a form the first record appears in the field boxes and they begin to edit that record thinking they are actually adding a new record. I have a button that clears the displayed record fields for a new entry but it would be easier if the form, on open, does this as they often don't notice the new record button.

How do I get the form to automatically set itself up for a new record on open? Thanks

 

[jadams0173]

I think there is a form propety that says "allow new records only" or something like that. Everytime the form opens it opens to a blank record. Check the form properties.

 

[jrbarnett]

In the Form_Load event, put

DoCmd.GoToRecord ,,acNewRec

John

 

[Cero21]

Thank you both for your extremely quick responses. I ended up going with John's suggestion as my users need a edit ability as well. Thanks again!