reference a field on a subform from owner form

microsoft.public.access.gettingstarted

22 Feb 2005 10:06 PM

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

22 Feb 2005 10:20 PM

DebbieG

I have found this website very helpful:

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

me.fieldx = me!NameOfSubform.form!fieldz

HTH,
Debbie

Show quote

"mcnewsxp" <mcour***@mindspring.com> wrote in message
news:%238E9RrSGFHA.444@TK2MSFTNGP15.phx.gbl...
|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