Originally Posted by
jrajul
Until the new record is updated or saved, the autonumber field has a null value. So your function may lead to division-by-zero errors.
I recommend PMB/NZ([Loan_No],1)
The immediate result will be innaccurate, but will fix itself after the table or record has been refreshed.
you can put docmd.refresh page in the "after insert" event of the form to be certain of the update.
The NZ funtion is only available in Access. If you are working with other programs, you may have to use the iif function instead instead.