How do I print out a single record from a Form button

[Tfrank]

I need to add a button to a form that will print only that record displayed, based upon the layout and fields in a report to a single label printer. I know there must be a simple way to do this, but I can't figure it out. I have found a easy way to print out all the records, but I only want to print the one displayed. Thanks for the help.

Tfrank

 

[MHadden]

I have never used this for labels, but it works for reports. You might want to give it a try.
Put the following code in the "on click" event of your button. Replace the word Index below with the name of your unique identifier (usually an autonumber)

Private Sub btnOnForm_Click()
DoCmd.RunCommand acCmdRefresh

Dim strDocName As String
Dim strWhere As String
strDocName = "NameOfYourReport"
strWhere = "[Index]=" & Me!Index
DoCmd.OpenReport strDocName, acViewPreview, , strWhere

End Sub

HTH -Michael