combine records from child into one textbox in parent

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.
 
A

Arvin Meyer [MVP]

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Child Timelines to Multiple Parents 0
Display Child Records in subform 7
Parent Child Wizard Abscent 0
Extracting a cell value 2
subform displays no records when its recordsource is a query 0
If No Records in Subform, Parent Form Record doesn't display 4
Problem with subform parent/child linking 2
DLookup in Continuous form 0

Top