Updating records

[Dubya007]

i have a VB6 frontend to an Access 97 DB. my superiors want me to make the front end to be able to update the output automatically. for example, when you type in a new machine number everything about that machine comes up with out having to hit the next button or the find button. is this possible? i can put the zipped up project as an attachment if need be

[Pasvorto]

Sure... Use the key press events and as each key is pressed, try to receive the record.

[Dubya007]

um...............i'm not understanding, which keys are you speaking of?

[mendhak]

There will obviously be a textbox where the machine name is typed. In the keypress event of the textbox, you can do a check with the database for that machine name and bring up its records.

[Dubya007]

do you know where i could find an example of this? i don't know about the keypress event. i can do the search(i think) but i donno about the keypress event. thanx for the help