Okay guys I have this code which will print the report for a single record.
Private Sub cmdPrint_Click()
Dim StrCriterion As String
StrCriterion = "[LotNumber]=" & Me![LotNumber]
DoCmd.OpenReport "rptWithdrawals", acNormal, , StrCriterion
End Sub
Now this code works fine but here is the problem. It is based on one unique identifier for the record (LotNumber). However what happens is that I have two primary keys for this table so using one of the identifier brings me other transactions done for this LotNumber. So I would like it to be able print the one single record by pulling from these two unique identifiers together LotNumber and TransactionDate. Help will be greatly appreciated.