How To Caluculte the maximum values from the table and assingn to the textbox

[har273]

Hi there

Thanks For reading this thread.
I am a beginer of access programming.

I have a problem in doing a task with my form.

Actually I have a button to add a new record which opens a new form there i enter the values to the record. But when I press the Addnew record button I want to calculate the maximum of the Identity field +1 and open the new form with that new number which i have calculated. How can i do this

[jzwp11]

It sounds like you need to use the DMax() domain aggregate function.