Combo box variable and asp page 3

[accessguy52]

Hello - I'm sorry if my subject line was not explicit enough, but here's my problem. I'm fairly new to ASP and I need to accomplish the following:

I have a page with a combo box that mimics an Access form where the values in the combo box are criteria for a SQL statement that when a button is pushed, an Excel page comes up listing who fits that value. I've got all the code I need to get working in ASP. My problem is this:

how do I tell ASP to "Select * From the value in the combobox where id equals combobox value and send the recordset to Excel in the browser". I have no problem with that. The combo control is called "Title". I think the compiler is saying, "WHAT control from WHAT page?"

Here's the code:

sSQL = "SELECT DISTINCT TBL_MASTER.Record_ID,[TBL_MASTER].[Last_Name], [First_Name] AS Name,"
sSQL= sSQL & " TBL_HR_Data.Application_Received, TBL_POSITIONS_OPEN.Position_Title,"
sSQL= sSQL & " TBL_POSITIONS_OPEN.POSITION_ID, TBL_HR_SEC_SHARE.Phone#1, TBL_HR_SEC_SHARE.Phone#2,"
sSQL= sSQL & " TBL_HR_SEC_SHARE.Phone#3, TBL_HR_SEC_SHARE.Email, TBL_HR_Data.Notes "
sSQL= sSQL & " FROM TBL_MASTER LEFT JOIN TBL_HR_Data ON TBL_MASTER.Record_ID = TBL_HR_Data.Record_ID INNER JOIN TBL_POSITIONS_OPEN RIGHT JOIN TBL_POSITION_CANDIDATES ON TBL_POSITIONS_OPEN.POSITION_ID = TBL_POSITION_CANDIDATES.POSITION_ID ON TBL_MASTER.Record_ID = TBL_POSITION_CANDIDATES.Record_ID INNER JOIN TBL_HR_SEC_SHARE ON TBL_MASTER.Record_ID = TBL_HR_SEC_SHARE.Record_ID LEFT JOIN TBL_SECURITY_DETAIL ON TBL_MASTER.Record_ID = TBL_SECURITY_DETAIL.Record_ID"
sSQL= sSQL & " Where TBL_POSITIONS_OPEN.POSITION_ID= '" & Request("Title&quot & "'"

Ignore everything but the last line. It's the request part.
Am I doing that right? It's probably an absurdly simple solution, I just don't know it.

Does this request or does it need more clarification to everyone? Thanks much in advance. Mike

 

[mwolf00]

He should have given stars when it worked - you guys (onpnt and Tarwn) did a lot to help. So - I'll give you the stars... -----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com

 

[onpnt]

Thanks Mike. Much appreciated Just a suggestion: faq183-874

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[Tarwn]

Thanks for stars (mwolf) Mike
Glad it worked for you (accessguy) Mike,

Hmm, Mike and Mike...I'm trying to think of something funny to say, but I can't

-Tarwn
11 hours till beginning of vacation time! --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[accessguy52]

I had no idea how to put stars or anything in my post - so here's some for you guys [stars]. Thanks again....

Until next post...
accessguy52

 

[accessguy52]

Tarwn - 10 days til MY vacation time!! [smiley]

 

[Tarwn]

Heh, by then I'll be back in the horse collar running in circles

And for future reference (mwolf already covered it so no need to duplicate his effort) when you wish to add stars, the link is located:

About 1/2 to 1 inch down under arrow:
  |
  |
  |
 \ /
  V

--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[accessguy52]

Thank you. Duhhh!! Until next time...

accessguy52

 

[mwolf00]

What does "vacation" mean? [flush] -----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com

 

[Tarwn]

Vacation:
the whole month before vacation:

the week before vacation:

last afternoon working:

The last hour before vacation time:

Leaving work to start vacation:

First morning of vacation:

First Night of Vacation:

Next morning of vacation, finally getting home:

Next Afternoon of Vacation, waking up:

First Day Back:

First Monday after day back:

Your coworkers monday afternoon:

Heh, I have more but by now I've already created a nice little extra load to my server

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
FAQ FAQ20-2863
= new Forums.Posting.General.GettingAnswers()