set value question

[luanhoxung]

hi !
i need some helps for my form.
i want to set value of 1 record (R1) in main form from record of sub
form.
my record of sub form is total value of other records.
i try with Total in even AfterUpdate
Total.value = forms!mainform. form.R1
but it didnt work.
Pls help !!
thanks !
Luan

[salad]

Re: set value question

luanhoxung wrote:

hi !
i need some helps for my form.
i want to set value of 1 record (R1) in main form from record of sub
form.
my record of sub form is total value of other records.
i try with Total in even AfterUpdate
Total.value = forms!mainform. form.R1
but it didnt work.
Pls help !!
thanks !
Luan
>
>

Some methods to reference another form. We have MainForm and Subform
Forms!MainForm! SubForm!Field1
Forms!MainForm! SubForm.Form.Re cordsetClone.Re cordCount
Forms("MainForm ")!SubForm. ..
Forms("MainForm ")("SubForm")!F ield1
Me.SubForm.Form .Recordsetclone
Me.SubForm!Fiel d1
etc