Adding 1 to a number

[Garabed]

i have a table with the following fields autonumber mnumber ,fname,
lname, etc. i need to find the last number entered in the table and
add 1 to it. I tried using dmax mnumber +1 but it finds the higest
value in mnumber and then adds 1 to it every time the user submits the
form.
what i need to happen is everytime the user opens the form it dispalys
the mnumber +1 for the last record entered. if they wish to continue
using that sequence they can but if they need to change it it will
increment according to the new sequence they enter. I hope this makes
sense.

 

[tina]

you already posted this question in microsoft.public.access.queries a half
hour earlier. please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10

 

[Garabed]

you already posted this question in microsoft.public.access.queries a half
hour earlier. please don't multipost. for more information, seehttp://home.att.net/~california.db/tips.html#aTip10






- Show quoted text -

Sorry i realized i posted it in the wrong place. Wont happen again.