add & increment number automatically but not autonumber

M

MarcSains

I would like to automatically increment a number in a colomn. I was able to
type in the number and hit the down arrow key in old Access. But have Access
2007 and this feature does not work. I do not want to use auto number as the
numbers have already started and are not used in every instance. Any
Ideas....??
 
S

scubadiver

Form's "before insert" event:

Me!FIELDNAME = DMax("[FIELDNAME]", "[TABLENAME]") + 1
 
Top