Assign next record number

[imwalrus38]

I'm using a form in acces 2003 to enter data into a table. I'm using auto numbering in my table. I want to create a macro that automatically assings the next number when the form is open. presnetly a number isn't assigned until data is entered in the first field and the field is exited.

Thanks

John

 

[jammyp]

Hi, you could use MAX(ID) + 1