munkeyroot
Registered User.
- Local time
- Today, 13:50
- Joined
- Jan 13, 2011
- Messages
- 76
Hey everyone
I have been trying to do an append query to duplicate my frm_main and all my subforms on a command button.
i found this on the net from MSoft
https://support.microsoft.com/en-gb/help/20...-detail-records
ok so i have copied this to the letter .... i think ... just obviously changed the table names to fit my DB. orders = frm_main orderdetails = mysubform
so when it comes to the append Query of my task, is says to:
"Delete OrderID from the Append To row of the OrderID column and type the following line in the Criteria row: [Forms]![Orders].[Tag]
This criteria selects the detail records where the OrderID is the value found in the Orders form's Tag property, the source OrderID."
ok so i changed it to my "frm_main" [Forms]![frm_main].[Tag]
so now when i click the duplicate button on my form it will copy the main form over ok but then get and INSERT INTO message
"The INSERT INTO statement contains the following unknown Field name: "forms!frm_main.Tag"
I've put the append query on here to show what i have done so far
RolesSelect_ID is PK and Main_ID is FK
any thoughts guys?
munk
I have been trying to do an append query to duplicate my frm_main and all my subforms on a command button.
i found this on the net from MSoft
https://support.microsoft.com/en-gb/help/20...-detail-records
ok so i have copied this to the letter .... i think ... just obviously changed the table names to fit my DB. orders = frm_main orderdetails = mysubform
so when it comes to the append Query of my task, is says to:
"Delete OrderID from the Append To row of the OrderID column and type the following line in the Criteria row: [Forms]![Orders].[Tag]
This criteria selects the detail records where the OrderID is the value found in the Orders form's Tag property, the source OrderID."
ok so i changed it to my "frm_main" [Forms]![frm_main].[Tag]
so now when i click the duplicate button on my form it will copy the main form over ok but then get and INSERT INTO message
"The INSERT INTO statement contains the following unknown Field name: "forms!frm_main.Tag"
I've put the append query on here to show what i have done so far
RolesSelect_ID is PK and Main_ID is FK
any thoughts guys?
munk