Address search

[Blitz]

I have a database of buildings and their addresses.What I want to do is have a button on a form that when you click it, it asks and finds the address your searching for. BUT I want it so you dont have to type the exact address, ex a building is on 1234 palm avenue, I want someone to be able to just type &quot;palm ave&quot; in the search and it will find all address with palm ave in them. So that the person doesnt have to know the exact building address to search for it. Is<br>there any way to do this? If so could someone give me an overview of how. <br><br>Im fairly new to this and have little experience using the VB code so if you could explain it as dumbed down as possible Id appreciate it, thanks

 

[Guest_imported]

Create a query based on your table add all the fields you will want to use in the query. Place in the criteria row in your under the address field<br><br>like &quot;*&quot;& [Enter Address] &&quot;*&quot;<br><br>when you run the query this be what you are wanting to do.

 

[Blitz]

Yup thats what I was looking for. Thanks