Help!!
I have a report which requires the user to enter two dates. The report then only displays records which fall between the period entered. This part of the report works fine, however on the report i have a label with the visible property set to No. In the OnFormat property for the section the label appears in, i have the following event procedure;
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
If Me.placement >= 2 Then
Me.labelname.Visible = True
Else
Me.lablename.Visible = False
End If
End Sub
The procedure checks the number of records per person and only displays the label where the count is >= 2.
However, i im encountering problems where there are no records for the dates entered by the user, i get the following error msg;
Run Time Error '2427'
You entered an expression that has no value
How do i get around this? can anyone help?
I have a report which requires the user to enter two dates. The report then only displays records which fall between the period entered. This part of the report works fine, however on the report i have a label with the visible property set to No. In the OnFormat property for the section the label appears in, i have the following event procedure;
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
If Me.placement >= 2 Then
Me.labelname.Visible = True
Else
Me.lablename.Visible = False
End If
End Sub
The procedure checks the number of records per person and only displays the label where the count is >= 2.
However, i im encountering problems where there are no records for the dates entered by the user, i get the following error msg;
Run Time Error '2427'
You entered an expression that has no value
How do i get around this? can anyone help?