Continuing Number Textbox

[alyon]

In access 2007, I have a textbox on a form. I would like the textbox to automatically show a number from the previous form's textbox +1... so start at one, and go as high as necessary. I'm not really even sure how to explain it well, so I haven't been able to look it up much. Any help would be greatly appreciated, I can try to explain myself better if necessary.

[alansidman]

If you are not already using autonumber in your table, then you can apply this format to the field.

Alan

[alyon]

How do I set my table up to make my field do that? And if I do, that will show the numbers automatically in my form?

[alyon]

I set up autonumber, but that doesn't help me? I need it to automatically insert the next number into the textbox on my form, autonumber doesn't do that. it comes up (new)

[alansidman]

Once you populate the form with other information, then the "new" will change to the next sequential number.

Alan

[alyon]

I was already using autonumber for another field, once I had figured out what it was. However, I figured out how to do it, and incase anyone else is wondering, the way to do this is: =DMax("[textbox]","form")+1 in the default function of your textbox. :]

[alyon]

But, thank you for your help. :]