I have a box in my main form called "standard comments" and I want user to choose as many comments as they want from a sub-form connected to it. Example, the sub-form may have a check box next to each comment, and when the user ticks these checkboxes the chosen comments are all displayed in the main form (or any other page). Can this be done at all? If yes, can u please tell me how? Thanks a lot.
sub-form and forms
- Thread starter Suzy
- Start date
well, the main form will display only the chosen comments. Say that I am marking student A, in the "general comments" box there is a link to subform which has all comments. If I choose say, 1.good, 2.well done and 3.be careful about spelling, then only these 3 should only be displayed in the main form. Am I making myself clear? Any ideas?
Mile-O
Back once again...
- Local time
- Today, 08:44
- Joined
- Dec 10, 2002
- Messages
- 11,316
What was wrong with parent/child form I gave you a couple of days ago?
The idea was that the main form and subform hold different recordsets but you are now trying to "denormalise" the structure.
Look at the details by The Doc Man on this thread for a better understanding of why what you "appear" to be doing is wrong.
The idea was that the main form and subform hold different recordsets but you are now trying to "denormalise" the structure.
Look at the details by The Doc Man on this thread for a better understanding of why what you "appear" to be doing is wrong.
