Field in the main form based on a subform
Expert
Windows 7 32bit 
Access 2007
Hello my friends
I have a main form and a subform
In the main form field collects the values in a field in the subform
Does not show results
Put this shows me an error
= ([Forms]! [FrmTable1Subform]! [Expr1] - [mom])
or
=Sum([Forms]![frmTable1Subform]![momout])
an error
VIP
Windows 7 64bit Access 2010 32bit
Recommend you give the subform container control a name different from the object it holds, like ctrDetails.
If textbox is in subform footer section, reference in textbox on main form:
=[ctrDetails].Form.[controlname]
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.
Expert
Windows 7 32bit Access 2007
Hello again
Repeated error
= Nz ([Forms]! [FrmTable1Subform]! [Total]; 0)
VIP
Windows 7 64bit Access 2010 32bit
Doesn't look like what I suggested.
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.
Expert
Windows 7 32bit Access 2007
Thank you very much June
I've been to solve the problem
The error was in the name of the subform
fill subform field based on main form value
Subform Combobox based on Main form combo box
Posting Permissions
Reply With Quote