Setting Main Form Field Using Sub Form Field

Slate

New member
Local time
Today, 16:57
Joined
Apr 29, 2003
Messages
7
Ive tried searching the forums but cant find out how to do this....

ive got a total value on a subform that i want to refer to it from the main form, and set a value from it

ie.
sub form: total field
main form: total field (not saved, just on form for calculations)

how do i get it across?
Forms!Subform!Field = Forms!mainform!Field
dont seem to work :(
 
I think these syntax examples are correct....but someone help me out here if they're not!

If you have a value on your main form, and you want to refer to it from the subform:
Me.subformfield=Me.Parent.Form.mainformfield

If you have a value on your subform, and you want to refer to it from the mainform:
Me.mainformfield=Me.subformname.Form.subformfield
 
Just set the control source of an unbound textbox on the main form to =Forms!MainFormName!SubformName!ControlName
 

Users who are viewing this thread

Back
Top Bottom