Addition (1 Viewer)

[Thedon123]

I would like to create an addition in my form how would i do that.

I have some subform that have numeric values filled in them. I want to transfer these down the page and update as more values are added in the form.
I have three subforms with different sets of numeric values. Each will be transfered down to a specific box then added together.

 

[edtab]

!

If I understand your question correctly, you have a main form and multiple subforms showing together on the same screen and that you would like to transfer values from your subform into the main form.

The main form would have a name that Access recognizes... eg.
"forms!frmWorkOrder". Your main form would also have fields or controls in it. They would also have names. So, to refer to a field in your main form called "Description", you would then go
"forms!frmWorkOrder!Description".

The same goes for your subform. Now to transfer values from a control in your subform to a control in your main form, you woud code in one of your events :

Forms!frmWorkOrder!Description.value = SubformName!SubfomrControlName.value

You need to substitute your form, subformname and control names accordingly.

Hope this helps.

edtab

 

[Thedon123]

Tahnks a lot that solved the problem