I have a db to manage projects which are numbered YYSeqential# i.e. this year: 07001, 07002 etc.

I would like create each new project number based on the previous project number + 1 rather than going to the last record, looking at the number and then typing the next number in for the new record.

Any help for the newbie would be grand.

Cheers

You can use a DMax formula to find the largest number and add 1 to it.

You might want to try this link. Parts of it may give some help.

http://www.vbaexpress.com/forum/showthread.php?t=11350

Gary