Hello -
I have this report in Access 2007 with a drop down box that you can select a name of an Employee and then enter a date range [Begin date] and [End date] if the employee selected did not have any case Routed to the report comes back with an #ERROR for the date range and the Assign to field is empty…
Is there a way I can have access show me the date range the person enter and the name they selected? Since we print these report and email them – it looks a bit odd that we have to hand write in where the #ERROR is with the date and then will in the Assign to with the name we selected.
Appreciate any suggestion and help thank you!
Below is the
VB code that call the drop down box... not sure if this is any help in understand the process but i figure i add it in ...
Code:
Private Sub Command8_Click()
On Error GoTo Err_Command8_Click
Dim stDocName As String
stDocName = "CloseItemsBlue_rpt"
DoCmd.OpenReport stDocName, acPreview, , "RouteTo = '" & Me.Combo10.Column(1) & "'"
Exit_Command8_Click:
Exit Sub
Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click
End Sub
dBforums
>
show name on report even when data is NULL
11-02-11, 08:19
Linear Mode
