ok so am making some head ay here I still need some help though.
so if I take off the line where am adding a new record and the "if" statement, the code works fine. with it, it doesn't.
I want my form to add the autonumber automatically when the form is loaded with a new record...
this...