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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Paragraph numbering in Word 1
How can the font and size of (all) citation numbers be altered? 1
Generate increment numbers automatically 2
How to auto increment integer entries without autonumber in 2007 3
Not use autonumber 6
Name of file opened, being viewed 2
Access 2007 looses actual increment high value 4

Top