Very strange subquery field disappeared with a filter

[Tal]

Hi all,

So I have this search filter that functions with a text field and button on
a form. The code, which works, is as follows:
The issue, however, is that when the filter is on, the data in the two
fields that are actually subqueries in the recordsource query
[expClientMainName] and [expClientFirstName] disappear. This is especially
odd given that the search variant is actually searching those 2 fields.
Thoughts?

Cheers,
Tal.


Option Compare Database
Option Explicit
Private Sub btnClientSearch_Click()
Dim varWhere As Variant

If Not IsNull(Me.txtClientSearch) Then
varWhere = "([expClientMainName] LIKE ""*" & Me.txtClientSearch & "*""
OR " & _
"[expClientFirstName] LIKE ""*" & Me.txtClientSearch & "*"" OR " & _
"[txtGroupName] LIKE ""*" & Me.txtClientSearch & "*"")"
End If

Me.Filter = varWhere
Me.FilterOn = True

End Sub