Custom Autonumber

Is it possible to create a customer format like 0235-ABC Where "235" autoincrements and "ABC" depends on a related record in another table? Obviously it would have to be text format due to the leading zero and once it gets too 999 to bump over too 1000 etc

Accepted strings:

0111-ASD
1021-ERW


thanks in advance

You would be better off to simply leave it as an autonumber, and in the form, append what ever value you need to the end. You shouldn't need to save it like that in the table.

Side note, there is no guarantee that an auto number will increase in a logical order. The only guarantee is that they will be unique. And now you know!

Here's a sample that demonstrates a method of using the DMax() function to auto-increment a daily job number based on the office responsible for the job. It also follows the advise that speakers_86 has already given.