🚀 go-pugleaf

Try putting your code in the Change event.  Only do this though if the data
entered is in the listbox since you don't want to do your lookup on partial
entries.  Hence:
- Write code to look up the text value in the listbox.
- If found invoke your code that populates the textboxes.

--
Later,
Tony Fountain
Digital Horizons, Inc.
tonyfo@primenetNoSpam.com
tony@dhiwebNoSpam.com

Andy Duckworth wrote in message <01bce79d$c3d18060$87577ec2@duckfather>...
>Urgent help please!
>
>I have a user form in an Access 97 document that has a combo box looking up
>info from a table. Connected to this I have various textboxes showing
>related info from the database. When I change the value in the combo, the
>values in the text boxes change as expected. What I want is to be able to
>type something into the combo box and have the values in the text boxes
>change dynamically. Can any body help in this. I will be needing to do this
>in a VB5 app in the near future as well as in Access.
>
>Thanks in anticipation.
>
>email at either duckfather@dux.globalnet.co.uk      or
>andy_duckworth@allied-colloids.co.uk
>
>Cheers
>
>Andy