Help to SELECT And Display Data Please

[paul]

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

[Tonatiuh]

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.


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


Good Look!

Ulises

[paul]

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