I have a form with an embedded subform. For each record in the mainform, I could have several subform records available to choose. When I print, I am unable to print the mainform record along with a single subform record. When I go to the print function, I'll select "selected record(s)", and it will print the selected mainform record, but it also prints ALL the subform records. I only want it to print the selected mainform record and the single selected record in the embedded subform.
I was given advice that it is not good to print from a form but rather I should design a custom report that can filter just the records of the subform I want printed. Any views on how this is done when dealing with the embedded form?
Basically I was thinking of doing this by placing a Print button on my mainform page that would take and filter out all but the currently selected records that are being viewed on the Mainform and the merged Sub-form, then send them to the custom Report to print. But once again I have no idea how to do this.
To describe my expertise in Access would be to sum it up in the word "Nada". I'm a very very basic user so please in your answer be as detailed as you possibly can. I realize that there might be a huge detailed answer to this question so feel free to type as big of explaintion as you desire to. I apprieciate any information you can provide into this situtation even if its a website to go to or a differnt way to approach the problem.
thanks a lot in advance!
I was given advice that it is not good to print from a form but rather I should design a custom report that can filter just the records of the subform I want printed. Any views on how this is done when dealing with the embedded form?
Basically I was thinking of doing this by placing a Print button on my mainform page that would take and filter out all but the currently selected records that are being viewed on the Mainform and the merged Sub-form, then send them to the custom Report to print. But once again I have no idea how to do this.
To describe my expertise in Access would be to sum it up in the word "Nada". I'm a very very basic user so please in your answer be as detailed as you possibly can. I realize that there might be a huge detailed answer to this question so feel free to type as big of explaintion as you desire to. I apprieciate any information you can provide into this situtation even if its a website to go to or a differnt way to approach the problem.
thanks a lot in advance!
