Hi,
I have a a bound form with autonumber ID, I added a a "New" button to the form with the script ( DoCmd.GoToRecord acForm, "form1", acNewRec)
if pressed the new button the ID field shows "New" until the form is dirty it will generate the record ID and a record will be created.
How to make the form generate the ID without typing or selecting values. i.e, when the user press the new button a record ID will be generated and a record is created ?
Thank you very much