Im using macola vba ide to modify a form. I use the text box "ItemNo" when it loses focus i get 2 numbers from fields from the database (unit_price, uom_ratio) then i make a simple division to display a result on another Text Box created by me.
The problem is, that when there is more than one order for such item, then there is more than one unit_price. I need to navigate thru the ListBox but there aren't any helpful events... listbox only has GotFocus and LoseFocus. OrderNo has those 2 plus KeyDown, KeyUp and KeyPress.
I hope i made myself clear. An OnChange event would solve my problem in a second!!... any helpful ideas? Thank you.
The problem is, that when there is more than one order for such item, then there is more than one unit_price. I need to navigate thru the ListBox but there aren't any helpful events... listbox only has GotFocus and LoseFocus. OrderNo has those 2 plus KeyDown, KeyUp and KeyPress.
I hope i made myself clear. An OnChange event would solve my problem in a second!!... any helpful ideas? Thank you.