get highest invoice number from table

[hullstorage]

i have a table of invoice numbers and i have a form with a field for invoice numbers
what i want to do is get the last or highest invoice number last used from the invoice table by default

help!!!

many thanks

 

[KenHigg]

You can use a dmax() function to get the value and use that for the default value.

 

[hullstorage]

You can use a dmax() function to get the value and use that for the default value.

can you give me some idea on this
as i am fairly new to this and have never used the dmax funtion

thanks

 

[KenHigg]

May I suggest MS Access help and give it a go from there as a first step as my explanation of how to use it wouldn't be as thorough (And why try to re-invent the wheel?). If you get hung up after that post back what you've tried and I’ll give it a shot -