Run Time Error: 2465

[JNariss]

I am trying to have my form "frmMoveToProd1" to use the SendObject to
populate an email I send to users with the fields that are within the
form and a subform.

I need to include the field: Moved_By on the subform:
Move_To_Production_subform. I currently have to following coded line
which is giving me error: 2465

strMoved_By =
Forms!frmMoveToProd1!Moved_By.Move_To_Production_subform.RecordsetClone

The error message tells me that the database can't find the field
"Moved_By" referred to in my expression.

I thought someone's expertise could get me through this.

Thanks,
Justine

 

[Douglas J Steele]

Take a look at http://www.mvps.org/access/forms/frm0031.htm at "The Access
Web" for how to refer to controls on subforms.

Be aware that when it says "Subform1" or "Subform2" there, it's talking
about the name of the subform control on the form, which may or may not be
the same as the name of the form being used as a subform.

When you create a subform by dragging one form onto another, the subform
control that's created is automatically named to the same as the form that
you dragged. However, if you add a subform control from the toolbox, it'll
be named something like "Child0". As well, if you drag the same form onto a
main form more than once, the subform control will be named something
different than the form that you dragged.

 

[JNariss]

Thanks a lot Doug I will check out the article and go from there.