Error message when print a form

N

Nancy Tang

When i click the command button to print a report through a form, there is a
error message shown: "The database engine could not lock table "Inventory
Adjustment Table" because is already in use by another person or process."
What it mean? Is my command button set wrongly?

Table name:inventory adjustment table
Form name: inventory adjustment form
Report name: reports
Primary key : IAF#

Below is my event procedure in the print command button,is it correct ?
Pls kindly advice.TX
*****************************************************
Private Sub PRINT_Click()
On Error GoTo Err_PRINT_Click

Me.Refresh
DoCmd.OpenReport "REPORTS", , , "[IAF#]=" & Me![IAF#]

Exit_PRINT_Click:
Exit Sub

Err_PRINT_Click:
MsgBox Err.Description
Resume Exit_PRINT_Click

End Sub
 
Top