Updating problems

[xtrareal22]

Hello!so I have this stock form with an update button.basically it's a filter so when clicked the name of the stock is typed in so the details can be displayed.at the same time my unbound field is set to visible.in this unbound field a quantity is keyed in and the quantity is added with the data in a field called quantity and outputed in the quantity field.My problem is after this has been done for multiple items the quantity for the item in the stock table shows the updated quantity..but if the item is keyed in my sales form the quantity of the item being displayed is the initial quantity before the update has been made!It is like no change has been made to the quantity of the item at all!any ideas to why this happens and what I should do???

[June7]

This is saving aggregate data and a very poor db design. Stock on hand should be calculated whenever needed. Review http://allenbrowne.com/AppInventory.html

As for why your arrangement is not working, would have to review db structure and code. If you want to provide, follow instructions at bottom of my post.