I am having a problem with a counter that uses DMAX + 1 to get the number. It works fine until it reaches 10 and then it stays at 10 from there on ? Heres the code.
MyLineNo = DMax("line", "tblnquote_d", "id=" & MyId) + 1
MyLineNo = DMax("line", "tblnquote_d", "id=" & MyId) + 1