Newbie needs help searching database

[crothersb]

Ok, connection to the database is set. I have one table called users. The table has four columns called Lastname, Firstname, Phone, Address.
I have a textbox, a button, and four labels coresponding to the five columns in the table.

What I want to be able to do is allow a user to type the last name of a person in the textbox and search the database after clicking the button. If a record is found the four labels mentioned above should display that persons first name, last name, address, and phone. Also the last names are unique so the search will not return more then one result.

If you could post some code to help me get started that would be great.

Thanks

~Brad~

 

[jmcilhinney]

Follow the Data Walkthroughs link in my signature. It provides step by step instructions for various scenarios, including searching data.

 

[crothersb]

I finally got it working after 36 hours of searching. Thanks for all your help and I need it again. I am using the query builder can you suggest any websites that would list some of the filters you can use.