Auto populate sequential unique id's

Discussion created by Tonyalmeida on May 20, 2011
Latest reply on May 24, 2011 by Tonyalmeida
Does anyone know how to automatically sequentially calculate numbers in an ID field. I have a VBA script that updates fields with a click but i would like to auto populate a field with sequential number. The field i need auto populate when i click is Address_ID. I need it to some how look at the last number and determine which would be next and populate it. I need to some how incorporate into my VBA script i have. Any help would be gratefully appreciated.