Subform extraction.

[Aeon.Divine]

Im needing to program a couple of modules to make calculations with subforms cells.

The first one its easy, i need one of the subforms columns to be automatically equal to be equal to the product of another two columns. Just as one would normally do in excel =(A1*A2)

Im not sure where i should place this module.

The second one should add every cell of a certain column and show the result on a label below the subform.

The first program operates only over the subform as the second one takes some values and shows the result outside.

I'll be gratefull if you could help me to sort this out.
Many thanks in advance.

 

[George Too]

Not sure I'm following you on what exactly you want to accomplish as seems to me you are not calling things the proper name (I don't think we have cells in access). However, many calculations can be done in the underlaying query for the subforms instead of creating modules for them.

 

[Aeon.Divine]

Ill try to explain it Again.

http://img153.imageshack.us/img153/115/screenshotxo2.jpg


[ I had posted two doubts, by the first one i have already figured out by myself. ]

This is the screenshot of my form. In in, theres a subform with the name of some items the user is wanting to buy. the user will select the items entering them in the subform, and i need the sumatory of every price in the "Precio unitario" Column, to be showed in the TOTAL textbox i added below.

Is it understandable now ?

----

I guess no one knows...