Filter email field on continuous form gives error

[Ruegen]

Private Sub txtEmailFilter_AfterUpdate()
Me.Filter = "[SchoolEmail]= Me.txtEmailFilter"
Me.FilterOn = True
End Sub

I can't seem to get this to work

I keep getting an error

eventually I will use nz() but for now I just need to figure out why the code above is wrong.

[June7]

Don't include variables within quote marks, that results in the variable name as literal text and not the value of the variable. Reference to control on form is a variable. Concatenate variables.

Me.Filter = "[SchoolEmail]='" & Me.txtEmailFilter & "'"

[Ruegen]

Don't include variables within quote marks, that results in the variable name as literal text and not the value of the variable. Reference to control on form is a variable. Concatenate variables.

Me.Filter = "[SchoolEmail]='" & Me.txtEmailFilter & "'"

Great - filtering does work now however it has to be exact - wondering if I can place a "like" in the code so I can filter what is typed. Also how to return the form without the filter - nz() doesn't seem to work for me.

Also I do get what you mean, rather than referencing the textbox you want me to reference the value within it. Makes sense.

[Ruegen]

I used this for replacing the nz

If Not IsNull(Me.txtEmailFilter) Then
Me.Filter = "SchoolEmail Like'" & Me.txtEmailFilter & "'"
Me.FilterOn = True
Else
Me.FilterOn = False
End If

still would like it to filter only what is typed not exact

[June7]

Use wildcards with LIKE, otherwise might as well just be =.

Try:

Me.Filter = "SchoolEmail LIKE '*" & Me.txtEmailFilter & "*'"

[Ruegen]

Use wildcards with LIKE, otherwise might as well just be =.

Try:

Me.Filter = "SchoolEmail LIKE '*" & Me.txtEmailFilter & "*'"

ah - wildcard * got it. And put another on the other end to signify between wildcard?

[June7]

On each end to match any characters found before and after the input. Use either or both.

[Ruegen]

On each end to match any characters found before and after the input. User either or both.

Thanking you