Print Screen

[Becca]

I have created a form with a print button. When the user
clicks on the print button, all the forms start to print.
I just want that one certain form that the user is looking
at to print. How do I code that?
Thanks!
Becca

 

[Rick B]

Forms are fir viewing, adding, and changing data. Reports are for printing.

You should tell your button to print a report and include code to tell it
which record to print. The following example is from my employee database.
It is used to print an employee worksheet for he currently displayed
employee....



Private Sub Print_Button_Click()
If (IsNull([UserID])) Then
' If no employee selected, stop procedure
Exit Sub
End If
DoCmd.OpenReport "Admin - Employee Worksheet", acViewNormal, "",
"[UserID]=Forms![frmSINEmpDataMaintenance]![UserID]"
End Sub






I have created a form with a print button. When the user
clicks on the print button, all the forms start to print.
I just want that one certain form that the user is looking
at to print. How do I code that?
Thanks!
Becca