Autonumber not visible

[steve1111]

Hello,

I have a form that should generate and autonumber when a record is started. As soon as i start typing in the first field, the auto number field goes from (New) to blank. Even if i add an me.ID.requery or an me.ID.SetFocus on the AfterUpdate event it does not bring in the number.

In the SQL table it is actually storing the number like it should, it is just not updating on the form.

Any ideas?

Thanks

 

[pbaldy]

If the back end is SQL Server, the autonumber isn't assigned/shown until the record is saved. If memory serves you can get it in the form's after insert or after update event.

 

[steve1111]

Thanks Paul, i did a accmdSaveRecord after update on the first field and that did the trick.

 

[pbaldy]

Happy to help!