Adding Custom Button w/ VBA to find next ID

Discussion created by DanielGray on Jun 29, 2011
Latest reply on Jun 30, 2011 by jbarrette-esristaff
Hi Everyone

First off, I am a Python guy, not a VBA guy, so this is foreign to me....  I know I could write code very easily to find the max value of a field and add 1, to give me the next ID, however, to take the python, put it on a button & display the output in a small pop-up box, I dont believe is possible...  however, I am pretty sure it can be done with VBA....   does anyone have any ideas for me??  The actual goal was to have ArcMap setup to automatically fill in the next ID when a new point is created in a layer, but the only way I have found to do this, it only looks at the last record of the table (according to ObjectID) and adds 1 to that....  grrrrr

Please respond with any ideas!!!!