Print button on a form to print a range of records by highlighting records in a subform
Posted on 2011-03-15
For simplicity, I have a form called A and an embedded suform called B where A and B are linked by an identifier called ID. Subform B is displayed in datasheet view with a field called SN. So one ID on form A could have multiple same IDs on subform B displaying a one-to-many SNs. What I want to accomplish is the following:
The user highlights the records in the suform B (one column display of SN), and then clicks the Print button on the main form A and the report called "Labels90F0069" is opened in preview mode based on ONLY the highlighted records in subform B. This VBA coding is beyond me and I could really use expert help. Thanks.
stDocName = "Labels90F0069"
DoCmd.OpenReport stDocName, acPreview