Incrementing autonmber with string

[Butch]

Hi,

I am incrementing my autonumber with vba because it is part string and part integer. eg.ABC001
And this works fine. But now I have to change the lettering of the string part of the autonumber. I'm using the DMax function. But once I change the letters in the string part, everytime I add a new record it always looks back to the largest number beside the original string. eg. ABC199. so every new record comes out like this XYZ200 where it should be XYZ229 ....

Is there a way of getting around this?

thanks in advance.

 

[Liv Manto]

Did you create a new field for XYZ or is ABC and XYZ both in the same field?

If you created a new one, then its looking at the original field, maybe?

Can you send the the code, and table format?

Thanks.