Hi there
i have a problem , in one of our projects , due to some reason we used form as report by this i mean e.g
* we had  a list of companies in company list box
* On Selecting Company all of its products are filled in            Product List box
* and then when u select product its detail are shown in a fram  which comprises of fields like Catagory,precautions ,Old/New,Package Details etc etc
* on that same form we had given a print button ,on pressing it all the details of a specific product of a specifice company are being copied on a white form which has nothing but collection of labels some labels for Field Headings and some for fields Values
* ther we hav print ,cancel label as well on focusing these labels get enlarge and Red

Its Working V Well and is in business for several months

Problem:--
This form works well for one product , what if we want to have
detail of all products of a company ,e.g abc company makes 140 products then how can we get the information of all these products on that on form
REmember we cant use crystal reports Due to some reason
Regards


____________________________
@#@#@

You can simulate grid and display your data in a drawn table. You would then have to make something like

Page 1 of 20

Which will allow you to display data that couldnt be displayed on one form. For instance lets say that maximum rows that could be displayed on A4 paper is 30. I you have 115 articles, you would need to have 4 pages displaying 30 articles each, respectively. Clicking on the print button, you can allow user to choose between printing current or all pages.

____________________________
If you find the answer helpful, please mark this topic as solved.