How to Print current Transaction?

[cap.zadi]

Hey there,



I have a form where i perform some test and go to print command which is supported by a report for tests.

right now i have put query which ask 1st which test no want to print so i just put testno and print the page but i am looking to print as i enter the record and go to print so must print the last transaction only?

how it can be plz?

zee

[alansidman]

Here is code I use to print the current record using a report based upon a query. I put this code on an on click event for a command button.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

    Dim stDocName As String

    stDocName = "Submission"
    'DoCmd.OpenReport stDocName, acNormal, , "[ID] = Forms!frmClients!ID"
    DoCmd.OpenReport stDocName, acViewPreview, , "[ID]=Forms!frmClients!ID"

Exit_Command28_Click:
    Exit Sub

Err_Command28_Click:
    MsgBox Err.Description
    Resume Exit_Command28_Click
    
End Sub

Make sure to rename the controls to match your names.