Hi All, I am slightly new to VB and I am having difficulty on creating a duplicate record and adding as a new record on same table. Here is what i'm looking for as I cannot wrap my head around how to do this. I have a database with a dozen tables (ie. tblPage1, tblPage2, tblPage3, ..., tblPage13, tb...