Combo Box Problem In MS Access 97

[ahabichd]

I am using a combo box to display item numbers from an inventory table. When the On Change event of the combo box is triggered a number of text boxes are filled with the item's description, price etc.
This works fine when I select an item from the drop-down list of the combo box, but not when I type a value into the text field of the combo box.

 

[jfgambit]

Move the code to the After Update Event of the Combobox

"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"