smtazulislam
Member
- Local time
- Tomorrow, 00:09
- Joined
- Mar 27, 2020
- Messages
- 806
Hello !
I want to print form current data print order by EmployeeID.
I have two pages report. Print view showed data but print out command do not printing data. It is printing manually inserted reports data only.
I try this code
Advance thanks.
I want to print form current data print order by EmployeeID.
I have two pages report. Print view showed data but print out command do not printing data. It is printing manually inserted reports data only.
I try this code
Code:
Private Sub cmdPrint_Click()
'Print current record
If IsNull(Me!txtEmployeeID) Then
MsgBox "Please enter an employee ID", vbOKOnly, "Data Required"
Exit Sub
End If
DoCmd.OpenReport "rptBackVacation", acViewReport, , EmployeeID = " & Me!txtEmployeeID"
Me.Visible = False
End Sub