Incrementing Numbers

[anastazia1117]

I have to enter lot numbers into one column on a table, and most of the time, they are sequential. In Access 2003, when I'd enter two numbers (i.e. "1119301" in row 1, then "1119302" in row 2), Access would predict that I would want "1119303" in row 3 when I pressed the down arrow key.



Since we've converted to 2010, Access doesn't predict anything anymore, and entering lot numbers is fairly tedious. Does anyone know how to turn this function on or set a script/macro to do it?

It's for an existing data table. We have records in our database from 2005. The numbers will not all be consecutive. We may only issue 5 lot numbers one day, but the next can be 30 or so. I'm only concerned with the final digit incrementing in the next record.

I'm doing the entry on a table. I don't care about the previous numbers, just that it does it from this point forward.

All of the data entry is in Access, not Excel.

Thanks for your help!!!

[boblarson]

Use a FORM and you can do it. Use the table and you are out of luck. So, wanna use a form?

[anastazia1117]

I'm open to using the form, as long as it's as quick as it was using the table.

[boblarson]

You can set the form up to be a datasheet view so it can look like it was the table. But in the form's BeforeUpdate event (not in the event property dialog but in the VBA Window), put this code (with the appropriate names changed to fit your actual control name):

Me.YourControlNameWithTheNumber.DefaultValue = Me.YourControlNameWithTheNumber + 1

So leave the ME part alone and change the YourControlNameWithTheNumber to be the name of the text box which is bound to the field you want to increment.