Pull data based on Text box info

9 Mar 2006 2:51 PM

jimstruckster

I'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated, Thanks

9 Mar 2006 6:57 PM

Mike Brind

jimstrucks***@gmail.com wrote:

> I'm looking to display information pulled from a database based on
> information the user puts into a text box. The user will enter their
> sales rep number and I want to hit a table and return their name as
> soon as they tab off of the text box. Any ideas or help would be
> appreciated, Thanks

Use the javascript blur event to submit the form.

--
Mike Brind

9 Mar 2006 7:09 PM

Bob Barrows [MVP]

jimstrucks***@gmail.com wrote:

> I'm looking to display information pulled from a database based on
> information the user puts into a text box. The user will enter their
> sales rep number and I want to hit a table and return their name as
> soon as they tab off of the text box. Any ideas or help would be
> appreciated, Thanks

It sounds as if you wish to do this without submitting the form, so you will
need to do this with client-side code using the xmlhttp object. See a
client-side scripting newsgroup such as microsoft.public.scripting.jscript
for details.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.