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
Post a Comment