Originally Posted by donsi
"Eval(prm.Name)" only ready Forms!Subform!ControlName rather than reading it like suggested.
qryUpdateUser likely has a field that refers to the subform. That's where the validation fails when the subform calls it, and that's likely because you haven't put the correct subform reference in that query field. Try that, and if not successful, you should post
- main form name
- subform control name (NOT the name of the subform unless they happen to be the same, which is not advised)
- name of the field being referenced on the subform
Keep in mind that a subform loads first, so if you are trying to get any values from the main form when subform loads, it will fail.