Calculated Control

[MooseMan]

I have a calculated control which calculates a value based on two textboxes and two Listboxes on the same form. The two list boxes get there data based on underlying queries.

The problem is that the calculation does not perform accurately.

This is my code

=([txtTotalDefaultCY])-(Nz([txtAdminLiabilityPrincipal])-Nz([txtPrincipalPaid])-Nz([txtPrincipalHonored]))

The formula performs the first calculation and then ignores the rest.

Any help would be appreciated.

 

[JeremyNYC]

put in debug.print lines for each of the controls you have and see if the values are really what you think they are.

Also, rename your list boxes, as txt usually denotes a text box (won't make your code run better, but it will help us (and you) debug your app).

Jeremy

=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.