VB Search Code

[BTervuren]

Please take a look at this code and let me know why I get the a compile error:

Method or data member not found

' If Test Date
If IsDate(Me.Testdate) Then
' Add it to the predicate - exact
strWhere = strWhere & " AND " & "Projects.[Testdate] >= " &
GetDateFilter(Me.Testdate)
ElseIf Nz(Me.Testdate) <> "" Then
strError = cInvalidDateError
End If

 

[Duane Hookom]

One error is your assumption that we know what GetdateFilter() is. Also, I
wouldn't use Nz() without providing the 'if null' value.