Field Value based on highest value

[Simon]

I have a data entry form and in one of the text boxes i want the default
value to appear as the next highest number in this field.

e.g The field name is Pnumber and if the highest value in this field is
10856, when I open the form to input data i want 10857 to appear in the text
box. I want the user to be able to change this number if they want.

 

[MikeJohnB]

Me.Pnumber.DefaultValue = DMax("Pnumber", "[YourTableNameHere]") + 1

[Brackets only needed if there is a gap in the "Table Name"]

try on load event or on open event of the form. Because it is only the
default value you are setting, the user can change the value by entering a
new value in the field.

Does this help?????

Kindest regards

 

[Jeff Boyce]

Simon

Search on-line for MS Access and "Custom Autonumber".

The basic concept is that you'd set the default value of the control to be
the DMax() of the underlying field, plus one.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Simon]

Many thanks, tried this and works fine.