I can't help thinking your structure is all wrong.?
What it you need Accessory4?
Normally you would just use an ID field that identfies that accessory, select it and any descriptive data comes in from it's table?, not copy descriptive data all over the place?
I can't help thinking your structure is all wrong.?
What it you need Accessory4?
Normally you would just use an ID field that identfies that accessory, select it and any descriptive data comes in from it's table?, not copy descriptive data all over the place?
Thank you, its only 3 accessories there is no 4th, and I just don't want the user to fill same fields again when the "Requested Items are given" but if "Different item is given" then the user have to fill different item with its different accessories.
So again I wanted to find a way to fill all the fields in subform2 (tblProvidedItems) when "Requested Items Given" is chosen instead of filling them manually again.
May be you are right and my db is not well designed from the beginning but this is the best I could do.
you need to investigate the Real Name of that subform by going on design view of your form, clicking on that subform and
looking at Property Sheet->Other->Name.
then substitute the Real name to the code i gave you.
you need to investigate the Real Name of that subform by going on design view of your form, clicking on that subform and
looking at Property Sheet->Other->Name.
then substitute the Real name to the code i gave you.
I struggle to see why you would want to copy fields from a sub from to another. It just sounds like a data structure problem. Generally, which fields in subform1 would be relevant to subform2 - that would need a copy? I just can't see this.