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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

have form update as I type

Status
Not open for further replies.

Travis33

Programmer
Nov 20, 2000
31
US
I have a simple database with a form that I have set up that
I enter in a part number and using the after update property
will find the record. I have it set up with a combo box that as I type it fills in the rest of the string. I want it to be scrolling the rest of the text boxes that I have to as I type but it only changes the data when I finish the string in the combo box. I am wanting the textbox that has the description to be updating as I type too.

This might sound confusing but in a nutshell I want to start typing in a part number and as I type the description is changing too. So if I am not sure on the part number I can start typing and look at the description and know the part I am looking for. I have been fighting this for two weeks now and I would really like some insight to my problem
Thank You,
Travis
 
That is tricky to program.
But if you add the Description field to your combo box also then as you start keying in the part number the Decriptions will be right next to it.

I do it like this, click in the combo box so it drops down then as you start typing it will find the part number and the description will show next to it.
If th epart numbers are sorted then as you type you will see similar parts next to each other.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top