|
|
Create New Record based on Exisitng record
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, tblCustomer, tblInspection ...) and I am looking to loop through all tables, and only duplicate 1 particular record (the one thats currently in focus from my combo box) and then add it as a new record. Note: The columns in each table tblPage1,2,3... are different in that one table would have several date and result columns and another tables have less columns. I have attached my MS Access database/vb below. The part that i'm working on is frmNewfromExisingInsp and I believe it may have something to do with Recordsetclone... Thank you in advance for your help!!!