Need to increment the highest number + 1

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.
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Increment Number 6
increment on add new record 3
find highest value in field, add 1 and then display in form 3
form load operation isnt working 4
Auto Increment Field or Identity Field In MS SQL Server 0
Continue sequence from highest number in field 1
use VBA to run query duplicate and and increment if number already in table 6
Number subform items sequentially 3

Top