I need to move a value from a main form to subform so that i can use it in a calculation in the subform. the subform is derived from a table. How can i do this?
You should avoid moving data from one data source to another as this is duplicating data. You can perform the calculation from the value on the mainform by referencing the main form's control in your calculation. Get back if this is not possible.