Add one to last

[pwicr]

I have a field that I want to automatically generate the number using the last one.

My numbering is SPF828 so I want the next one to auto-generate SPF829.

this is a text field.

 

[John Big Booty]

You can use the DMax() function plus one to create your own auto incrementing number.

Something like;

    If Me.YourCounter = 0 Or IsNull(Me.YourCounter) Then
        Me.YourCounter = Nz(DMax("YourCounter", "YourTableName"), 999) + 1[COLOR="DarkGreen"] '999 represents the seed  (first number) of your series[/COLOR]
    End If

Additionally instead of storing a text field you could simply use a numeric field and then use the Field's Format property to add the text prefix, something like;

"SPF"0