Can I create an auto increment field based off the value of the AutoNumber field? My table has an AutoNumber filed as the PK. Because MS Access always increments it ensures the field value is unique. I want to use this as the base for creating the value of a new field ([Field1], e.g...
[Field1] = [AutoNumber] + 10000
If I had three records, the value of [Field1] would be 10000, 10001 and 10002.
This calculation can't happen until the record becomes active and Access assigns a value to the [AutoNumber] field. I was thinking I may be able to write some VBA on the "After Update" event for the record that runs the calculation and inserts the data into [Field1]? Is this possible or am I stuck using the NZ(DMax) option?