i have a form named supplies containing a subform supplied product details.in a subform i hav different products supplied by a supplier.the total amount for each product is obtained by[total]=[unit price]*[quantity].i had also added the sum of all total of products on a subform n then displayed the total amount of all products supplied to a main form.
now i want this value of unbound text box to be stored in a field of a table as well coz i want to apply further queries upon it to find monthly supplies.but m fail to do this.can anybody direct me