By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

print current record in form and sub form

P: 4
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.
Oct 21 '06 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
You say you are trying to print the current selected record on a form.

How are you printing it. In a report, screenshot, what??
Oct 22 '06 #2

P: 4
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.
If there is a better way to do this, I am ready to try.
Oct 22 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.



I am trying to print it while I am in the form.
If there is a better way to do this, I am ready to try.
Oct 22 '06 #4

P: 4
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.
Is there any other way to do this while staying in Access?
Oct 22 '06 #5

P: 4
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.
Oct 22 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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.OpenReport "ReportName", , , "[ID_Field]=" & Me.[ID_Field]

Note the record will have to be saved before the report can access it.
Oct 23 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.