Dmax

[Jrw76]

I have a form with a textbox(Text202) bound to a field(PlateNo) in a table. I would like to use Dmax to find the largest value in that field and add 1 to it, and reapply this to the textbox in the form. I would like to have this behind a button. I can't use AutoNumber in this situation, or I would and I'm unsure of how Dmax works. Any help would be great.

[Bob Fitz]

Perhaps you could use an expression in the Default Value property of Textbox202. Maybe something like:
=DMax("[PlateNo]","[YourTableName]")

[June7]

Should that be:

=DMax("[PlateNo]","[YourTableName]") + 1

Be careful, until this record is committed table, another user could generate the same value - if this is a multi-user db.

[Missinglinq]

Is this going to be used as a single-user app or is it being used in a multi-user environment? It makes a big difference, as June7 suggested, when deciding where to place the code.

Linq ;0)>

[Jrw76]

Never Mind...Just figured it out.

[Jrw76]

Well, Only one user at a time for this form. So it should not happen.

[Bob Fitz]

Should that be:

=DMax("[PlateNo]","[YourTableName]") + 1

Be careful, until this record is committed table, another user could generate the same value - if this is a multi-user db.

Yes it should be. Thank you June
June and Linq make a good point about where the code is used.