combine records from child into one textbox in parent

  • Thread starter Thread starter hikaru
  • Start date Start date
H

hikaru

hi all,

I have a form with a subform. I have text1 in the parent form. what I want
to do is to use a code in the subform's AfterInsert, AfterUpdate and
AfterDelConfirm to select all its records according to a criteria and the
returned records are copied into one textBox in the parent form (in text1).
Is this possible? How can I do it?

Your help is appriated.
Thanks in advance.
 
That would be a gross violation of relational database Normalization rules.
Is there a reason that you need to duplicate data and put it all in a single
field?
 
Back
Top