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.

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