If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Why same report prints twice

[B]Dear All,
I really, really need your help! I woul be so thankful to you all if you could please help me out with this:

I have a form on which i have a command button to print report. When i select the record that I want to print on a report, then it prints creates the same report twice. It used to work perfectly alright but I dont know why it prints the same report twice. Awkwardly with some of the records it only prints once.

Private Sub cmdInvoiceClient_Click()
Dim strAccountRef As String
Dim strSQL As String
Dim intInvoiceExists As Integer
Dim ReportName As String
Dim rsNewDetails As New Recordset 'Making a recordest of new entry, to update fields with financial figures

'Me.Requery - cant use requery since it's based ona query and sorted by date of order
Me.InvoiceDate = Format(Date, "Medium Date")
Me.Recalc

If Len(Me.SageInvNumber) > 0 Then intInvoiceExists = 1

' If invoice has already been created for this Booking ID then
' tell the user, otherwise create an invoice for this Booking ID.
If intInvoiceExists = 1 Then
MsgBox ("An invoice has already been raise for this booking")