CodeChargenewbie
Posts: 114
|
| Posted: 09/06/2007, 9:12 AM |
|
I have 3 attributes (or columns), and I'd like to combine them into one search textbox. Basically, I want the user to search by a keyword, in this case first, middle, and last name. The textbox is currently set to accept the last name. I think I need to build a sql query, which I did, but I don't think it's working.
The name of the textbox is s_LastName. I clicked on the record and defined the connection. Then I went into the data source to build the sql query. I set s_LastName to contain like LastName, FirstName, MiddleName, respectively, in three where statements. I made sure to check OR and the s_LastName parameter was set as URL. But, like I said, it's not working. Is there something I'm missing???
The only thing I do know is I have no clue what to set the control source for the textbox I labeled s_LastName.
Thank you in advance.
|
