Need advice - keeping a counter

[RickT]

I'm a novice with access, but am learning. I'm trying to set up a counter system that will allow input of a beginning record Id number, then update it automatically (by adding 1 to it), and entering that in the form field for record number. Thus the user is presented with a pre-made record Id and can proceed to enter the remaining form info. The problem is - I've made VBL functions to do all this, but cannot figure how to keep a counter going after I exit Access - I can set the initial number, increment it and fill in the form control box, but the sequence is lost if I quit Access and re-enter. How can I keep the counter number alive from session to session?

I'm sorry if this sounds simple-minded, but as I say, I'm only learning.

Thanks for any advice.

 

[Travis]

You will need to retreive the last number used each time you start Access. You can do this using the DLookup Function or DMAX Function on the table that you are populating.

 

[RickT]

Thank you Travis, will try it.