How to increment no? when you have two fields in a table val1 en employee name. in a form u have this two as controlsource, the first textbox is val1 en the 2nd one is employee name. i have a command button add new record. how do i automatically increment the val1 textbox everytime i add new record. my table name is table1.
this is the code i made but it says invalid use of null
if me.newrecord then
me.val1=nz(Dmax (me.val1,"table 1",0))+1
end if
this is the code i made but it says invalid use of null
if me.newrecord then
me.val1=nz(Dmax (me.val1,"table 1",0))+1
end if
Comment