IbrBadri
Member
- Local time
- Today, 06:40
- Joined
- May 24, 2020
- Messages
- 35
Hi,
Can you help me?
I have main form and sub form "one-to-many" in the sub form have three key fields:-
Code1 reading from the main form "Index Duplicate Ok". 12Digits "123-456-789-012"
Code2 Field "Index Duplicate Ok" 3Digits "000". If code1 changed then can use the same code2 again.
Code3 "Index No Duplicate" contain the Code1 & Code2 to be a unique code3 automatically. 15 digits "123-456-789-012-345"
I am using "default value" = Code1 & Code2 in the "Property Sheet\Data" of my Sub-Form to fill the Code3 in a unique field automatically without enable editing to it.
However, sometimes, the Code2 in the Sub-Form changed, and need the unique Code3 to change accordingly in the same row.
Can you give me a sample of command to use in macro or visual basic?
Thanks in advance for your time to help.
Can you help me?
I have main form and sub form "one-to-many" in the sub form have three key fields:-
Code1 reading from the main form "Index Duplicate Ok". 12Digits "123-456-789-012"
Code2 Field "Index Duplicate Ok" 3Digits "000". If code1 changed then can use the same code2 again.
Code3 "Index No Duplicate" contain the Code1 & Code2 to be a unique code3 automatically. 15 digits "123-456-789-012-345"
I am using "default value" = Code1 & Code2 in the "Property Sheet\Data" of my Sub-Form to fill the Code3 in a unique field automatically without enable editing to it.
However, sometimes, the Code2 in the Sub-Form changed, and need the unique Code3 to change accordingly in the same row.
Can you give me a sample of command to use in macro or visual basic?
Thanks in advance for your time to help.