Nick;

I agree with David about not using DTC's! If you write your own code you will have more control over what you are doing. Also, David's sugestion is an approach I use often. Use one form to create the query and display the results. Another approach I sometimes use is a seperate form (a find form) to submit the query to an ASP page. Here is the code for the find page.

The search textbox always has focus. If you attempt to submit a request with an empty textbox you will receive a message.

< form action=Parts.asp Method=post id=frmSearch name=frmSearch ONSUBMIT=return NotEmpty() >

< label id=lblPartNumber
style=HEIGHT: 25px;
LEFT: 10px;
POSITION: absolute;
TOP: 150px;
WIDTH: 175px >

Part Number:

< /label >



< input name=PartNumber ID=txtFindPartNumber
style=position: absolute;
width: 60px;
top: 150px;
left: 150px;
maxlength=12
title=Enter Part Number. >

< input type=submit id=cmdSubmit name=cmdSubmit value=Submit Query
style=position: absolute;
width: 150px;
top: 150px;
left: 250px;
title=Submit Query. >


< input type=reset id=cmdReset name=cmdReset value=Reset
style=position: absolute;
width: 150px;
top: 200px;
left: 250px;
title="Reset. >


< /form >

< SCRIPT LANGUAGE=javascript >

function window.onload()
{
frmSearch.txtFindPartNumber.focus()
}

function frmSearch.cmdReset.onclick()
{
frmSearch.txtFindPartNumber.focus()
}

function NotEmpty()
{
strSearch = document.forms(frmSearch).elements(txtFindPartNumber).value;
if (strSearch.length > 0)
return true
else
{
alert(You must enter a value.);
frmSearch.txtFindPartNumber.focus()
return false
}
}

< /script >