Hello all. Not a newbie here, but it has been so long I might as well be. I am working on a problem reporting db and want to assign a sequential number to the problem after I hit the save button. I would like to, initally, show a blank ProblemID number field until all of the information is entered, then after hitting the SAVE button, have the table increment the ProblemID field by 1 (+1), then display the ProblemID number in the field. The user will then have the option to enter a new Problem or close the db.
I know I must use the UPDATE command but can't seem to find the appropriate SQL for ACCESS 2007 commands to enter in order for the SAVE button to initiate the action. Any help would be appreciated. Thanks everyone. David
