Good day.
I am trying to automate ID number generation. I created a table with the field "DeviceID" and gave it a default value of 100000000. When the first record is saved, I want to make the next record in the form start with the previous record's DeviceID value, incremented by 1.
Is there an easy way to code this into the GotFocus event? That seems to be the easiest way to may the procedure kick off. I am not worried about gaps in the numbering as I want the DeviceID field to be unique. And if there is an easier/better way (without using autonumber), I am certainly game.
Thanks,
Justin