I have developed a form which lists all of my customer names and informations. Then at the bottom of the page I have subforms with each having their own underlying tables. Then I have showed relationships so when a certain custmomer in the main form is selected all the customers information in the tabbed sub forms appears. Everything works fine.
Here is the problem. I am wanting on my report to just print the information for that specific subform (one line of table) for that customer that is currently shown on the main form or screen. When I set up a print preview command it pulls every single line from the table and won’t print just the current report that I have selected. So when I am wanting ot just have one report, I may have 30 reports appear and have to sift through each one to get to the one report I am actually after. If anyone has any ideas or found a solution to a similar problem your answers will be greatly appreciative.
Thanks.