reference a field on a subform from owner form

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

assign a value to a property on a subfprm 2
scroll to top of form with VBA 1
execute subroutine on subform 4
make scrollbar scroll up 11
too many on current events 1
Access Reference Subform's Control 0
search and replace query for a value in every column 5
On current 2

Back
Top