Hi there.
I have made a custom report (using the design view) I have set all the text boxes and labels.
Text boxes are in the details section and have been linked to a form, which includes a subform and some text boxes there...
it's a bit complicated but here goes:
This form, has a subform.
When you select something from a combo box, a new row appears, it's like those things like and order form, when u select something it automatically puts in a new row, incase if u wanted to order something else and u can fill the details there etc....
What I want is, in the report, how can I make it so that how ever many products this customer has ordered, i want that to appear in the report.
Is it possible? If so, how? I know for a fact that I linked the report text boxes to only the one text box in the subform, so it takes that value and prints it, but that's it.
I hope u follow, if not, please let me know.
thx
I have made a custom report (using the design view) I have set all the text boxes and labels.
Text boxes are in the details section and have been linked to a form, which includes a subform and some text boxes there...
it's a bit complicated but here goes:
This form, has a subform.
When you select something from a combo box, a new row appears, it's like those things like and order form, when u select something it automatically puts in a new row, incase if u wanted to order something else and u can fill the details there etc....
What I want is, in the report, how can I make it so that how ever many products this customer has ordered, i want that to appear in the report.
Is it possible? If so, how? I know for a fact that I linked the report text boxes to only the one text box in the subform, so it takes that value and prints it, but that's it.
I hope u follow, if not, please let me know.
thx