I have an On Open event for my form that says Me.fldX DMAX("[fldX]", "tblX") + 1.
fldX appears fine (it adds one to the highest number in that column and places the result into fldX), but when I enter values in the remaining fields and close the form, fldX show a value of 0 in tblX.
Any idea what I'm doing wrong? I'm doing it this way, because I want to add another button later on that gives the user the option of keeping fldX value the same rather than doing +1 again.
fldX appears fine (it adds one to the highest number in that column and places the result into fldX), but when I enter values in the remaining fields and close the form, fldX show a value of 0 in tblX.
Any idea what I'm doing wrong? I'm doing it this way, because I want to add another button later on that gives the user the option of keeping fldX value the same rather than doing +1 again.