Thanks, that did the trick. I've never seen that before, I'll have to go read up on it and how it works.

One last thing I need to do, but I'll try it again myself before asking.

>>Ok, fixed the blank page issue. Next step is getting it to show only the record for the number you type in. There's an input box and a submit button. I want to match the input to a record number and have it only display that data. Would something like this work?
>>
>>

cmd = "SELECT TOP(200) bol_number, pro_number, client_city, client_state, client_zip, customer_city, customer_state, customer_zip, ship_date FROM " + THESQLTABLE + "WHERE " + fdPrNo + "=pro_number"

>>
>>The code for fdPrNo is this:

fdPrNo = ALLTRIM(UPPER(Request.Form("PRNO")))

>>
>>I know the code in the query isn't correct, but is that where I would go about doing what I want?
>
>Try
>

>text to cmd textmerge noshow
>
>    select top (200) bol_number, pro_number, client_city, client_state, client_zip,
>     customer_city, customer_state, customer_zip, ship_date
>    FROM <<TheSQLTable>>
>    WHERE pro_Number = ?m.fdPrNo
>endtext

>
>This way you will use parameters in your command.