Bound field with autonumber ID, how to create new record ?

[ann06]

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

[burrina]

Access does not generate a Unique ID until you start entering data.

[June7]

Why would you need to commit the record without any data?

[ItsMe]

The only way I know is to populate a text field in that current record with an empty string and then save.

[ann06]

great thank you.. guys