Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Fri Sep 16 17:19:30 CDT 2005
Dear List:
Can anyone see why the following code should generate the error 2448 - you can't assign a value to this object in the line Me.Filter = strFilter?
Private Sub SetFilter()
Dim strFilter As String
strFilter = ""
If IsDate(txtDateFilterStart) Then
strFilter = strFilter & "fldPMScheduleStartDate >= #" & txtDateFilterStart & "#"
End If
If IsDate(txtDateFilterEnd) Then
If strFilter <> "" Then strFilter = strFilter & " AND "
strFilter = strFilter & "fldPMScheduleEndDate =< #" & txtDateFilterEnd & "#"
End If
If strFilter = "" Then
Me.Filter = ""
Me.FilterOn = False
Else
Me.Filter = strFilter
Me.FilterOn = True
End If
Me.Requery
End Sub
MTIA,
Rocky