Showing a selected value from a field

[Scotlands Lion]

What i need is.....

A textbox to show what number the next record in a table is going to be.

I have a column called "Series". This works like cars or a television series. There is series 1, 2, 3 & so on. What i would like a textbox on a form to do is show me the current series and what number the next in series would be. Is this possible?

[NoellaG]

Hi,

The last used (or highest) series number can be found using the DMax function :

DMax("fieldname","Domain name","criteria")
(see the build in help),

and of course if you know that you only have to add 1 to calculate the next series nr.