Hi there are you still using access ? I have come across your code to move a record from 1 table to another and struggling to get it to work. Do i make the new table with the same fields as existing one? Also is it just the new table I change in your code? Thanks very much for any help.