Bill, why not design a Report and put one control on it. Set it's control
source equal to the control on your form like so.
'If the control is on your main form:
=[Forms]![MyForm].Form.MyField
'If the control is on a subform:
=[Forms]![MyForm]![MySubForm].Form.MyField
'Place a command button on your form to print the report
Private Sub MyCommandButton_Click()
Dim stDocName As String
stDocName = "MyReport"
DoCmd.OpenReport stDocName, acNormal
End Sub
--
Reggie
----------
"HB2" <bg******@comcast.net> wrote in message
news:8e6yc.77989$Ly.46472@attbi_s01...
I have a form with several fields. I want to add a control to click on to
send the contents of one field to the printer.
Can someone offer help with the code for this?
Thank you
Bill