Queries to help calculate the values through datasheet

W

wannabepro

I have a combo box and its only one column combo box, the fields in the drop
down are Assets, Liabilities and Equity. I want Liabilities to be subtracted
from Assets so the Answer would automatically enter in with Equity field. As
for the columns I have 3 other columns and they are Borrower in the
house2000, 2001, 2002. Since, End of the year contains the drop down menu and
text, the values are being input in Borrower in the house columns. I hope I
made some sense here. And you can comprehend my query. I am using this form
as a subform. So its a datasheet. All the values are input in Borrower in the
House(year).
 
Top