Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

On Tab To Next Box

Status
Not open for further replies.

itorient

Technical User
Joined
Feb 20, 2004
Messages
29
Location
US
I have a text box in a web form wheer user put in the name. After putting in the
name and TAB over to next text box, is there a way to automatically
pre-populate other text boxes with general information based on the
user name entered? These basic information can be pulled from an
existing database, such as Access, Excel, etc. Then the user can continue to fill out other information. Thanks for any help in
advance.
 
itorient,

What you need to do is set up your sqlsearch string as the following upon leaving the name textbox:

searchstring = "Select [column names] From [database table] Where Name = '" & txtName.text & "'"

Then just get the information you request from the database and bind it to the appropriate textr boxes on your form.

Hope this helps,

Brian
 
Great, Brian, I will try this out. Thanks for your help on this.

Itorient
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top