I am trying to print the curent record that I have selected on the curent page in a form that I have created, with a subform on that same page. If I just do a "print" it will print only the first record. If I tell it to print selected record it will print the selected record in the form but not the subform. Any help with this would be greatly appreciated.
-
-
You say you are trying to print the current selected record on a form.
How are you printing it. In a report, screenshot, what?? -
I am trying to print it while I am in the form.Originally posted by mmccarthy
If there is a better way to do this, I am ready to try.Comment
-
If all you want is a screenshot of the form then Holding down the Ctrl button and clicking Print Scrn will copy it to the clipboard. You can then paste it into word and print it.
Originally posted by shullsComment
-
Is there any other way to do this while staying in Access?Originally posted by mmccarthyComment
-
I guess more details might help.
I have a DB of locations and contacts for different locations.
On the form that I have created there is an orgin and destination.
The origin is the main form the destination is the sub form. I have a combo box on each to select the locations. there is some other text boxes that other information has to be typed into. After I have selected the two locations I would like to print the current selection on the form and subform to a printer.Comment
-
The problem you have is that this is just not a feature supported by Access. If this is a vital component you would have to look at some of the screen capture software out there.
The only other option you have is to create a report and print that instead.
Set the report record source to the same as the form. Use a subReport for the subForm. Then open the report based on the criteria of the current record.
DoCmd.OpenRepor t "ReportName ", , , "[ID_Field]=" & Me.[ID_Field]
Note the record will have to be saved before the report can access it.Comment
Comment