Autonumber not updating until end of record set

[Hubler]

I constructed a database in access 2007, when you entered a new record the autonumber would be generated once you started typing in values. I have since upgraded it to an SQL back end and now the autonumber does not update until the recordset is completely entered. This is causing me serious problems with my subforms since the record will not update before I need to go to the subform. Any suggestions?

[pbaldy]

That is normal for SQL Server. You can force a save at the appropriate point before going to the subform with:

If Me.Dirty Then Me.Dirty = False