Help to SELECT And Display Data Please

Hi
I need to select from a database all the records containing HomePhoneNumber. I want the user to be able to enter the home phone number to search for . Then i need to display it. I need some ideas on how to do this. I've tried lots of things with no success. Any help would be appreciated .
Keeep in mind I am still new to VB.
Thanks

I can't put a more complete sample because I don't know what database object you are using. But I hope this idea helps you.

Code:

---

SELECT * FROM table WHERE HomePhoneNumber = '" & MyPhone & "'"

---

Good Look!

Ulises

I am using a ms Access database. One main problem is How do I show the results in a grid. The SQL search will return several records.Also can any one tell me just how to display the results?
Any help would be appreciated