saledo2000
Registered User.
- Local time
- Today, 00:55
- Joined
- Jan 21, 2013
- Messages
- 94
Hello,
I am new in acces world and will appreciate help from the experts.
I have created a form where is ID (e.g. CY_1000) set as the primary key in the 1st table. I would like to copy that ID, who is also set as the primary key, to another table for the current ID (e.g. CY_1000) opened in the form via check box "IDENTIFIED". I was looking through the forums and found one solution to append record in SQL but it cannot copy current ID because the other fields are different in the 2nd table. In the second table I have created field CY_Code for the records to be copied. 1st table has the field with the same name.
It would be ok if you have solution in VB code for "On click" option.
Thank you.
I am new in acces world and will appreciate help from the experts.
I have created a form where is ID (e.g. CY_1000) set as the primary key in the 1st table. I would like to copy that ID, who is also set as the primary key, to another table for the current ID (e.g. CY_1000) opened in the form via check box "IDENTIFIED". I was looking through the forums and found one solution to append record in SQL but it cannot copy current ID because the other fields are different in the 2nd table. In the second table I have created field CY_Code for the records to be copied. 1st table has the field with the same name.
It would be ok if you have solution in VB code for "On click" option.
Thank you.
