By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Automatic Number Increments In Microsoft Access 2002 Forms

P: 2
I am trying to automatically increment a number in a Microsoft Access 2002 Form called Frm Hazpot Entry Form. I have created a table called Next Hazpot Number in which there is one field to hold the last number used, I have a Form called Frm Next Hazpot Number which displays this information. I believe I have to have this form open in order to generate the number. This is as far as I have got - can anyone help.
Mar 19 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,365
You can use:
Expand|Select|Wrap|Line Numbers
  1. DMax("[Field Name]", "[Table Name]") + 1
to get the next number, there is no need for an extra table.
Mar 19 '07 #2

P: 2
Thank you I was trying to do it in a more complicated way.
Mar 20 '07 #3

Expert Mod 10K+
P: 12,365
Not a problem, good luck.
Mar 20 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.