By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

set value question

P: n/a
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
Oct 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.RecordsetClone.RecordC ount
Forms("MainForm")!SubForm...
Forms("MainForm")("SubForm")!Field1
Me.SubForm.Form.Recordsetclone
Me.SubForm!Field1
etc


Oct 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.