For some reason my database adds rows by itself. Blank rows.
this increases the Auto number and is screwing up my counting!!!
I dont see why it adds in a blank row but I have to end up deleteing them and then the autonumbers.
Its REALLy bugging me as it has happened various times!