More help with numbers please!

[csegal]

Thanks "HNA"
I had inserted this code under the on form_Current:
Me.Asset# = DMax("[Asset#]", "Table Name&quot + 1

And i substituted the "Table Name" with the name of the table where the data is from "SERIAL NUMBER LOG"
But i get a COMPILE ERROR "Method or data member not found"
then it highlights the .Asset# =

I am using access 97, if that matters...

Need more help please...
csegal@arrowair.com

 

[BillPower]

Me![Asset#] = DMax("[Asset#]", "Table Name&quot + 1

Not knowing what you're doing the above should do the trick.

Bill