Math on 2 fields on 2 different subforms

Todd · Aug 25, 2005

I have 2 subforms... one is assets the other is liabilities. On these
subforms I have a field titled "TotalAssets" and on the other is
"TotalLiabilities"

On the main form, I want a simple textbox to calculate TotalAssets -
TotalLiabilities.

Sounds simple, but I can't figure out how to do it. Thanks!!!

Al Camp · Aug 25, 2005

Todd,
Using your own control names...
= Forms!YourMain!frmAssets.Form!TotalAssets -
Forms!YourMain!frmLiabilities.Form!TotalLiabilities
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Roger Carlson · Aug 25, 2005

On my website (www.rogersaccesslibrary.com), there is a small Access
database sample called "SubformReference.mdb" which should be helpful here.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L