Need Help Creating an Autogen Number

[David B]

I am trying to automate a process that assigns a credit
number to a record dependant on a criteria. If a user
inputs data into a particular text box, then the "credit
#" will assign a value (with text, ie "S-1111") that is
incremental from the previous value assigned (which may or
may not be the previous record). I am also already using
an autogen number for my record ID in this table. Can
someone help me with advice on how I should proceed?

 

[Arvin Meyer]

I am trying to automate a process that assigns a credit
number to a record dependant on a criteria. If a user
inputs data into a particular text box, then the "credit
#" will assign a value (with text, ie "S-1111") that is
incremental from the previous value assigned (which may or
may not be the previous record). I am also already using
an autogen number for my record ID in this table. Can
someone help me with advice on how I should proceed?

Have a look at the sample database at:

http://www.datastrat.com/Download/AlphaNumeric2K.zip

While not exactly what you are looking for, the increment code should give
you an idea on how to write your own.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access