Form Error

C

Curtis

I got this database that just keeps track of revenues and expenses for a
small company basically. My Problem is I got a table called tblreconcil
which is supposed to hold our monthly debit and credit balances to show if
our records actually match up with our final bank total at the end of the
month. The information for this table is entered via a form called
frmbankrec.

Contents of the form:

Linked fields:
expense linked to tblexpense
revenue linked to tblrevenue

Manual entries:
month
year
closingbalance
openingbalance
credits
loans
notes

Calculated fields:
debitTotal = sum([closingbalance]+[expense])
creditTotal = sum([openingbalance]+[credits]+[-loans]+[revenue])
monthEnd = [creditTotal] - [debitTotal]

Once all this information is in this form it is supposed to be saved in the
table - tblreconcil. The problem is I am getting some errors on the linked
fields and for some strange reason on the "NOTES" field. The error that I
am getting is #Name? is displaying in the expense and revenue text boxes as
soon as I change from design view.

Is there anyone out there that can help me with this problem?

Thanks in Advance

Curtis McGrath
 
Top