As always thanks WGM, i know it's an old thread but i knew at some point I'm coming back to it, once i sort it, i will post resolution and mark solved....



The only reason i am moving everything down 1 row is that access can add data from the same row number every time and new records are at the top without scrolling down but understand why you stated it...