Why do you need to add 1 to it?
Is the ID not a AutoNumber?
Wouldn't it just get created when you save?

Hi Alex,

My apology, this is the customer number field [CN], unfortunately it is not an auto number. I am working with tables set up in the 1980's for some reason they don't use the [Counter] Field, which is an auto number, in the relationship between the work order table and the customer table. They use the [CN] and [IN] fields  both are generated by the software when a work order is created. Neither are auto-numbers. Sort of strange set up, but we are stuck with it for now. It is usually not a problem. In access I have no issues duplicating their code and creating work orders or whatever. On the web with CLassic ASP I am struggling with populating the [CN] field with a new number. I simply need to find the last number generated and add 1 to it for the new Customer Number.

Thanks,
Joe

I'd create a DMAX function in ASP that gets the largest current number, plus one, then are that to your field.

Code Vault: ASP DMAX / DMIN

Hello Alex,

Thank you very much for the information. These functions are exactly what I was looking for. Never even thought to look there.

Have a Great Day!