Hello All,
I have a form with a sub form
The sub form contains +- 20 fields. The primary field is “S_Code”
The records in the sub form always contain 1 “S_Code” value of Pendxxx (Pend223)
After a new “S_Code” (new record) on the sub form is created, I’d like to use the data from 15 fields of the “Pendxxx” record and copy them into 15 fields of the new record.
Field Names S_Code | txtDescription | txtPurpose | txtOffer
“Pendxxx” record Pend223 | This is the description |Get Order | 20% Discount
New Record ABC009 | This is the description |Get Order | 20% Discount
My thought is that I create a cmd Button to do this.
So the process will be:
1) Create a new record
2) Enter new S_Code
3) Click cmdButton … Find the “Pend” record on the current sub form and populates the current (new record) with the field values.
TIA
Detrie
I have a form with a sub form
The sub form contains +- 20 fields. The primary field is “S_Code”
The records in the sub form always contain 1 “S_Code” value of Pendxxx (Pend223)
After a new “S_Code” (new record) on the sub form is created, I’d like to use the data from 15 fields of the “Pendxxx” record and copy them into 15 fields of the new record.
Field Names S_Code | txtDescription | txtPurpose | txtOffer
“Pendxxx” record Pend223 | This is the description |Get Order | 20% Discount
New Record ABC009 | This is the description |Get Order | 20% Discount
My thought is that I create a cmd Button to do this.
So the process will be:
1) Create a new record
2) Enter new S_Code
3) Click cmdButton … Find the “Pend” record on the current sub form and populates the current (new record) with the field values.
TIA
Detrie
