Finding EOF record number

[gowans07]

I have a Table (Tbl_Orders) which holds information about orders, it consists of an order_id and is a number data type. Is it possible using vba to find the order_id value and then increase it by 1? If so how would i do this? Increasing by one is the easy part just need some guidance as how to retrieve the EOF/Last value of the table.

Thanks
TG

 

[plog]

This will get you the highest value in your table:

DMax("[order_id]", "Tbl_Orders")

 

[gowans07]

Works perfectly, Thanks