forms: Force sql server to create autonumber

[SteveApa]

Hi.
I have a form with recordset on sql server. Once the form is populated, I have a vb macro button to close the form. When the form is closed, it seems that that is when autonumber is created. But, before close, I want to use the "Not yet created" autonumber and use it to write a history change table with the same autonumber. How can I force sql server autonumber to be created before I close the form??


me.recordset.SaveNewlyCreatedRecord

I tried:
Me.recordset.update (Me being the form before close)
Me.recordset.movenext (thinking if I move next, the previous will be created)
Me.recordset.addnew (thinking this would create the autonumber on the field
docmd.gotorecord,"",acNewRec...

Thanks

[pbaldy]

Try

Me.Dirty = False

[SteveApa]

AWSOME! Thanks. How Do I mark it as solved?
Harrisburg, PA

[pbaldy]

Happy to help! You mark it via the Thread Tools dropdown at the top of the thread.