Get & display Next autonumber

[Guest]

Is there a simple way of retrieving the next autonumber (or the highest) to
display in a label.
The field IS in the form. Its from a DAO table
This is to be used to display the number of the next record added in a Add
Record form.
I know MAx(Number) will retrieve it but I don't know how to use it in Code.
Thanks for any help.

 

[Alex Dybenko]

You can use following expression, as a control source of a textbox:
=DMax("MyField","MyTable")

but be careful - this number can be added by other user in multi-user
environment

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

You say it's in a DAO table - I'm guessing you mean a DAO recordset?

If so (assuming the recordset variable is rst and your autonumber field is
called ID):

rst.Sort = "ID"
Set rst = rst.OpenRecordset
rst.MoveLast
lbl.Caption = rst![ID]

 

[Guest]

Thanks
I ended up using

Me.Label.Caption = "Account Number" & Str(DMax("MyField","MyTable") + 1)