I have a table tblInvoice, in which

[slames]

I have a table tblInvoice, in which 2 of the fields are invSeries and invNumber. I need to implement code to search these fields to find the highest number present where the invSeries is equal to user input. Once the highest number has been found, I need to add one and assign it as a new record in that table. My main problem is finding the highest number in that field, does anyone have any suggestions on how to do this?
Thanks
Steph

 

[GHolden]

You can use DMax function...

eg.

intMax = DMax("fldField", "tblTable", "WHERE fldFieldTwo = " value )

This will return the maximum value in fldField from tblTable where fldFieldTwo = value

There are two ways to write error-free programs; only the third one works.