Automatic Number Increments In Microsoft Access 2002 Forms

[EunBen]

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.

[Rabbit]

You can use:

DMax("[Field Name]", "[Table Name]") + 1

to get the next number, there is no need for an extra table.

[EunBen]

Thank you I was trying to do it in a more complicated way.

[Rabbit]

Not a problem, good luck.