reference a field on a subform from owner form

[mcnewsxp]

i forget how to reference a field on a subform on the owner form.

something like form.fieldx.value = forms![subform].[fieldz].value

tia
mcnewsxp

 

[DebbieG]

I have found this website very helpful:

http://www.mvps.org/access/forms/frm0031.htm

me.fieldx = me!NameOfSubform.form!fieldz

HTH,
Debbie


|i forget how to reference a field on a subform on the owner form.
|
| something like form.fieldx.value = forms![subform].[fieldz].value
|
| tia
| mcnewsxp