.Filter search string

Here is an easy one I am sure. What is wrong with the code below, I want it to filter based on the input of a textbox:
rs.Filter = ("materialnumber = 'text1.text'")

Try this instead:

rs.Filter = "materialnumber = '" & text1.text & "'"