VB Search Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One error is your assumption that we know what GetdateFilter() is. Also, I
wouldn't use Nz() without providing the 'if null' value.
 
Back
Top