control reference error (1 Viewer)

[jedder18]

=[Forms]![EpisodeTable subform]![EpisodeID#]


My formula to populate a field in a subform from another subform.
Keep getting the #NAME? error on the field.
Do I need to also reference the main form in this control?
I just can't think anymore, and I've done this numerous times in the past.

:banghead:

 

[RuralGuy]

Perhaps this link will help: http://theaccessweb.com/forms/frm0031.htm

 

[jedder18]

That's funny. I just added this form to my favs from a previous post I found.
Thanks.

 

[RuralGuy]

You have undoubtedly figured out that SubForms are *not* listed in the Forms collection.