forms - access calculated field misbehave -


i have strange issue ms access 2010, problem invoice form includes subform datasheet holds items bought, , in footer sums price of items sum() function !

in invoice form have 3 text boxes, 1 invoice cost sum of elements costs in invoice, other discount user input, , third net cost total cost minus discount

the strange behavior comes when change example number of bought items of element @ top of invoice while bottom of not visible on screen, net becomes 0!

however, if changed same element while bottom of invoice visible net calculated correctly !

any way in order figure out, uploaded small video showing problem

https://drive.google.com/open?id=0byhmj2iqibv0z3vmuvj5lvqymfe

any ideas?


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -