Hello Guys
I'm trying to transfer the value of a text box from a subform to a main form
I've written something like this shows an error
=Nz([frmGroupsSubform]![txtTotal1];0)
Hello Guys
I'm trying to transfer the value of a text box from a subform to a main form
I've written something like this shows an error
=Nz([frmGroupsSubform]![txtTotal1];0)
You need the correct syntax to refer to a subform from the main form.
See if this will help you: http://access.mvps.org/access/forms/frm0031.htm
Have to reference the subform container control. I always name the container different from the object it holds, like: ctrDetails. Try:
=Nz([ctrDetails].Form![txtTotal1],0)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks,June worked great . just took it out and it worked
Thanks,Steve for Doc version