Numbering Help

[jbphoenix]

I have a form that has a linked table as the record source. The linked table is in our MRP application. The ID field is text. I need to have all new records being entered start at ID = 4000 then go up by 1 each time a new record is entered. How would I do this? I know how to set the initial number of an autonumber but since this field is text I'm not sure what to do.

Any suggestions?

 

[RuralGuy]

DO NOT use an AutoNumber. Val([YourField]) will give you the value to which you need to add 1 and the Format() function will turn it back into text. Post back if you need further assistance.