Duplicating records in subforms

K

K

I am trying to duplicat records in my main form and in the subforms in a
form. I tried duplicate records command buttom wizard however it only
duplicates my main tables data(Please see tables below). My QouteID field is
a primary key and the relationship to all other tables (which are for the
subforms) are in relationship one too many. Each table below (DescID and
PressID) are in a one too many relationship with the MainTable by QouteID.
Can anyone help me duplicate these records. My subfroms do not duplicate.
Just my Main table in the form. I person gave me the code before but I
couldn't get it. Someone should make a hotline for this stuff.

Thanks

MainTable Notes about table: None
FieldName DataType Description
QouteID AutoNumber Primary Key
Cname Text Select From Customer Table
ExpDate Date/Time
SalesPName Text Select from Sale Person Table
Special Instructions Memo

Description Table Notes about table: ( For Subform Entry)
FieldName DataType Description
DescID Number
JobDesc Memo

PrePress Table Notes about table: ( For Subform Entry)
FieldName DataType Description
PressID Number
PrePressType Text Select From PrePressTypeTable
PressQty Number
UnitCost Currency
 
Top