"SELECT * FROM tbl_addresses WHERE Street_Name Like '" & TextBox1.Text & "%'"
The idea is that the string you build should contain the CONTENTS of the text box - not the textbox name...
I'm assuming ansi standard wildcard convention as well - the %. Every database that I've ever used or heard of uses ansi standard convention for wildcards, except for Access - it uses the * character. Also, note the apostrophes which will end up around the contents of the text box. I'm assuming that the field you're searching is either a text type field, or a date/time type field. If the field is numeric, you can't use the apostrophes, and you can't use like/wildcards. (you could cast the numeric data to a string, and use the like function with that though.)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert