B
bolanddj
Guest
Hello all... I am having a form/subform issue. I'm working on a project involving handling orders, and am using a mainform to handle displaying the pertinent mailing/total pricing information. A subform is used to track items associated with the order. The issue I am running into is that I've limited the subform's size to 5 items in both screen and print views because I'm using a capture of the currently used paper form that only allows that number. However, orders can contain more items, and I want to be able to print those, which I can't do right now. My hope would be to print the form multiple times with the mainform data the same as many times as necessary to capture all the subform entries. Is there a way to do this?
While I realize that the ideal printing solution is a report, this option is providing its own problems in that much of the form population is handled by queries that do not have the same syntax when dealt with in reports (can't fetch user's name by querying a userID because all data in report is generated at once, as opposed to a form where data is fetched when it is needed). The reports have proven very difficult to use and I would like to avoid them if possible for this aspect of the project.
I would appreciate any help you might be able to give me. Thanks...
While I realize that the ideal printing solution is a report, this option is providing its own problems in that much of the form population is handled by queries that do not have the same syntax when dealt with in reports (can't fetch user's name by querying a userID because all data in report is generated at once, as opposed to a form where data is fetched when it is needed). The reports have proven very difficult to use and I would like to avoid them if possible for this aspect of the project.
I would appreciate any help you might be able to give me. Thanks...
