L
Len
I am trying to set a filter in sub-report in the Open event using the
following code:
strOpenArgs = Parent.OpenArgs
Select Case strOpenArgs
Case "Expiration"
strFilter = "ExpirationDate <= #" &
[Forms]![frmMenu]![frmMenuSubform].[Form]![txtExpirationDate] & "#"
Me.Filter = strFilter
Me.FilterOn = True
End Select
When running the procedure after the statement
Me.Filter = strFilter
I am getting the following error: error 2101 “The setting you entered isn’t
valid for this propertyâ€
What can be the reason? Thanks.
following code:
strOpenArgs = Parent.OpenArgs
Select Case strOpenArgs
Case "Expiration"
strFilter = "ExpirationDate <= #" &
[Forms]![frmMenu]![frmMenuSubform].[Form]![txtExpirationDate] & "#"
Me.Filter = strFilter
Me.FilterOn = True
End Select
When running the procedure after the statement
Me.Filter = strFilter
I am getting the following error: error 2101 “The setting you entered isn’t
valid for this propertyâ€
What can be the reason? Thanks.