Calculateing in a form control

J

Jan Il

Hi all - Access 2002 - WinMe

I am creating a form to do date entry, and I want to display a balance in a
control on the form. I want to show a sum of the difference between two
other controls on the form. The name of the form is frmCheckRegister.

What I now have in the Balance control on the form is:

=Sum([Forms]![frmCheckRegister]![txtCheckAmt]-[Forms]![frmCheckRegister]![tx
tDepositAmt])

But, I am getting an #Error in the Balance control.

I would truly appreciate any suggestions on where I have made the mistake in
this calculation.

Best regards,
Jan :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Using the list form control: multi-selection possible? 3
Check register with running balance 0
DLookup in Continuous form 0
Dynamic Naming of Form Button 3
Sharepoint not capturing staff name when automation runs 0
Office JS api to handle redo/undo , delete event for content control class 0
Form hides control buttons 0

Top