performing a record search and displaying the data in a new form

Question

Hi,

I'm using sql server 2005 to store my records and i was wondering, how can I retrieve a record by performing a search? I've two forms, find/search page and find/search results page. A user can enter in data to perform a search and once they click on the search button, the data should be searched/retrieved from the database and displayed in a new form (find/search results page).

How do you go about doing this?

Thanks in advance