Incremental numbering from existing Number Sequence (2 Viewers)

[jcbhydro]

Rebecca,

The code I used in the Default Value of the Property Sheet is;

=DMax("[Member ID]","[Mail List]")+1

'Member ID' is my numbered Primary Key field and 'Mail List' is the database name.

regards,

jcbhydro