Unanswered: Searching by Like Address
I'm using MSAccess 2007 and trying search by address and got stomped and help would be appreciated.
1. form contains unbound text box to search
2. search and display all records containing (LIKE) the search text
3. double click to open that record
What I want to do is search the address that may contain the search text anywhere in the address, then list all matching ones so I can double click on one to open.
Combo box and lists will search the beginning of the address. I've also tried using subform but can't get it to work with SQL.
My latest attempt blow returns nothing:
unbound searchText in form header
unbound continuous form in detail
sSQL = "SELECT * FROM tbl_Units WHERE Address LIKE '%" & Me.txtSearch & "%'"
Me.RecordSource = sSQL
I've been working on this problem for days, and I'm ready to give up. Thanks.
Last edited by itchibahn; 04-01-12 at 01:48.
We're just a speck of dust in a universe.