WhereQuery
is
Nothing
initially. When you append a condition to the query you need a
WHERE
first. Here, you are using an AND
1) without a
WHERE
2) without any other where filter in the query
This might solve your problem
If Requester <> Nothing Then
IF WhereQuery <> Nothing Then
WhereQuery = WhereQuery & " AND Requester LIKE '" & Requester & "'"
Else
WhereQuery = " WHERE Requester LIKE '" & Requester & "'"
End If
End If