I have a DB that tracks Judgments and payments. In the main table [Referral], I have the judgment broke down into two fields as it consists of two separate parts - Civil Penalty Amt and Fee Amt. In the form I have a txt box that combines these amounts to display the Total Judgment.
Also in the form I have a subform to display Payments. The payments table breaks down the payment into two fields: AppliedCP Amt and AppliedFee Amt.
In the main form I added another txt box to display Total Payments, and then another txt box to display Remaining Balance ([Total Judgment]-[Total Payments]).
My question is how do I filter the form to display: All, Paid in Full and Remaining Balance?
I thought about adding a new field to the Referral table called "Closed" and have the user insert a date value when the Judgment is paid in full. Then I could filter the form using this field with a Null or NotNull value.
But, still wonder if there was a better way. I'd rather not use the "closed" option.
Thanks in advance.