Print Single Record

[stattech]

I have attached a file showing a screen shot of my order entry form along with details of my command button.



Upon hitting the Print Preview button I preview the invoice report for the selected invoice. I then hit print, select the appropriate printer and generally everything works as desired.

However ocassionally rather than just the single record report, it spews out copies of the form for hundreds of records.

Appreciate any words of wisdom!

[Access_Blaster]

This will print the record you are currently looking at if that will help.


http://allenbrowne.com/casu-15.html

[stattech]

I have editted the command button and 5% of the time I print the form rather than the report. Details of the button command:

Private Sub cmdPrint_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[Inv] = " & Me.[Inv]
DoCmd.OpenReport "Preprinted", acViewPreview, , strWhere
End If
End Sub
Private Sub Option143_Click()
End Sub


Appreciate your help!

[Access_Blaster]

Private Sub cmdPrint_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[Inv] = " & Me.[Inv]
DoCmd.OpenReport "Preprinted", acViewPreview, , strWhere
End If
End Sub
Private Sub Option143_Click()
End Sub

Private Sub cmdPrint_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[Inv] = " & Me.[Inv]
DoCmd.OpenReport "Preprinted", acViewPreview, , strWhere
End If
End Sub
Private Sub Option143_Click()
End Sub

Is inv a primary key? also the last two lines need to be removed.

[stattech]

Yes 'inv' is a promary.
I've removed the l;ast two lines.

Keep your fingers crossed.
Appreciate your feedback!

[stattech]

I have attached screen shots of my A/P and A/R forms, as well as shots of two different approaches I’ve tried to print a single record report.
Neither approach works 100% of the time – occasionally each button results in printing ALL records!

Thanks for your help!