Retrieving Form A Text Box And Using Information In SQL Statement

Hi everyone,

 So what I am trying to do is to have a simple textbox where the person enters a code.

 Then I need to have that code in an SQL statement like: SELECT Participant_Code FROM Contacts WHERE (this is where im stuck, I need to have something like WHERE Participant_code = code (code is the textbox ID))

 After this is done I need to keep this code from page to page, because I will need to add data from other textboxes to the database.

 Thanks