Adding Filter Using Macro

[TxTcher]

I have designed a penalty/payment tracking db.

One table contains "referral" info which includes the penalty amt and fee amt (I use a txt box on the form to calculate the total b/t these two amts)
Another table contains "payment" info which consists of monthly payments consisting of 2 fields - applied penalty amt and applied fee amt.

The form is designed using the Referral table with a Payments subform. I've added text boxes that total the Total Judgment = (Penalty + Fee), total Payment = (Applied Penalty + Applied Fee) and Remaining Balance = (Total Judgment - Total Payment)

I'd like to filter the form using 3 values: All; Paid in Full; and Balance Due.
I've added the combo box with these list values and am now struggling with the macro event.

The first part was easy:

Condition: [Forms]![Referrals]![Filter]="All"
Action: ShowAllRecords

What I'm having trouble with is the "Paid in Full" and "Balance Due" conditions of the macro

When I put in:
Condition: [Forms]!]Referrals]![Filter]="Paid in Full"


Action: Applyfilter: [Forms]![Referrals]![Remaining Balance]=0

I get no records (I only have 3 recs in the Referrals table at the moment, but I know that at least one of them has a paid in full balance.

Can someone help me with the "Paid in Full" and "Balance Due" filters? Thanks in advance.

[qa12dx]

if how u ve written ur queries and everything is ok then try the requery command after apply filter.

or post example here to us to examine