generate autonumber from vba

[Toeying]

Hello all,
I am looking for a way to generate the next number for a reference number field. I want to be able to get the ref.number for the last record in the table and then increment by some factor maybe 1. many thanks for your ideas..

TY

 

[Kryst51]

Have a look at DLookup, I used it in this thread which might help you figure it out.