Please help me stop dribbling over my keyboard!

Could really do with help!

I am having problems retrieving data from MS access db.
I am using a dropdown list in a form and giving the user some options to
select name, surname, country visited etc.
I am sending form data to an asp file which uses a select case query to
identify which sql query to execute.

Do I have to manually type in each table that will display my results from the recordset?
Or is there a dynamic option?
Can anyone provide a simple example or link?

Have shown code below
P.S If I am designing a web page with a search option is it best to have search from on the left of screen
in a page and use frameset in dweaver to separate pages?

Thanx 4 ur time.

G.

No worries I have learnt the code and it works.