Hi, I have an Access DataBase that keeps track of Press Releases by my company. What I really need is to produce a report which keeps track of whether or not the Press Releases have been approved. I have built the report structure, what I need is the code behind the button that launches it so that it only shows the records that haven't been approved. So far my feeble efforts have got me this:
Private Sub Command255_Click()
On Error GoTo Err_Command255_Click
Dim stDocName As String
stDocName = "ApprovalTracking"
DoCmd.OpenReport stDocName, acPreview, , "[Approval] NOT ("APVD"
"
Exit_Command255_Click:
Exit Sub
Err_Command255_Click:
MsgBox Err.Description
Resume Exit_Command255_Click
End Sub
The bits in bold are my code, the rest is from the wizard.
Thx for any help _______________
Stretchy
Private Sub Command255_Click()
On Error GoTo Err_Command255_Click
Dim stDocName As String
stDocName = "ApprovalTracking"
DoCmd.OpenReport stDocName, acPreview, , "[Approval] NOT ("APVD"
"Exit_Command255_Click:
Exit Sub
Err_Command255_Click:
MsgBox Err.Description
Resume Exit_Command255_Click
End Sub
The bits in bold are my code, the rest is from the wizard.
Thx for any help _______________
Stretchy
