Need to increment the highest number + 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my form w/sub forms I have a button to enter a new item, and I want the ID
field to automatically pick the highest ID and add 1 to it, and display the
result. Actually, it doesn't have to display the result as long as the field
is updated in the tables. In this particular case the field is not an
auto-increment field. I tried to figure it out but was unsuccessful, I'm a
noob with Access.
 
you can use the DMax() function to look up the highest value stored in that
field in the table, and add 1 to it. read up on the DMax() function in Help
so you'll understand how it works.

hth
 
Back
Top