Automated calculation

[delaikhi]

What would be an expression if I want a default value is equal the last record + 1? Thanks

 

[bob fitz]

Where do you want to do this calculation. In a form, or in a query.

 

[delaikhi]

Bob Fitz: on a form please

 

[bob fitz]

You could try this:

In the After Update event of the control (I assume this will be a text box) put the following code:

Me.ActiveControl.DefaultValue = Me.ActiveControl + 1

You will need to enter an appropriate value once, after that it should auto-fill with the incremented value.

 

[delaikhi]

Thanks, Bob!

 

[bob fitz]

Alternatively, may be better to set the Default Value Property of the control to:

= Nz(DMax("NameOfField","NameOfTable"),0) + 1