print current record in a form

mjuliao · November 14th, 2005, 11:35 PM

hi, I want to know how can I print the record I am seeing on screen in a form. Also I have a subform that doesn't prints only shows on screen and visible is set to always.

Please help.

SerranoG · November 15th, 2005, 08:57 AM

To print a particular record that you're seeing on the form you use a criteria for the command

DoCmd.OpenReport "MyReport", acPreview, , "[lngRecNo] = " & Me.txtRecNo

In the above example, the report opens to the record number equal to the record number you're viewing. For a subform to print, you need to put a subreport in your main report and make it's sourceobject equal to the same as the subform.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display the current record in textbox (form)	Vassala	Access	2	January 25th, 2007 05:05 PM
print current record on another form	jcellens	Access	7	February 14th, 2006 02:01 PM
How to delete current record in bounded form?	method	Access	0	June 19th, 2005 04:37 PM
UPDATE CURRENT RECORD	ranakdinesh	Classic ASP Databases	6	March 18th, 2005 02:22 AM
Print current record	vladimir	Access	2	September 10th, 2003 11:53 PM