Searching

[Matrix_zero]

I have an unbound form that pulls data on homes and properties, data such as a Tax Key Number, Address, Street Name, Square footage, Acrage... and many more out of a query. The problem is that I often get people who only have part of the address. N122 W22123 is the format of the addresses in the database. Often a person will only have 22123 something st. How can i do a search for anything containing 22123 in the address field. There may be several so being able to click the Next button and go to the next record that contained 22123 would be nice. Any suggestions?

 

[WayneRyan]

Matrix,

When you open your recordset, use:

"Address Like "*" & Me.SearchBox & "*"

Wayne