Calculated Checkbox

[Chris-eh]

I'm working on a formula for a control source on a checkbox on a form.
I have this formula

=IIf([OPBalanceDue]="$0.00",[OP Recovered]=True,False)

I'm trying to say if this OPBalanceDue field = $0.00 dollars then OP Recovered field/checkbox should check which would = True, and if not then it's false , so not check.

I think I'm missing something in the formula, cuz the control source accepts it as correct but when I go to a record that has $0.00 as the total the check box is not checked...I'm Stumped?

 

[Mile-O]

=IIf([OPBalanceDue]="$0.00", True, False)


And, on the form's OnCurrent() event put this line

Me. Refresh

 

[Chris-eh]

tried it and no luck.
I put the formula under the O/P Recovered control source and then on the subform it's on clicked into form properties scrolled to On Current property and clicked ... and choose code the added the line Me.Refresh looks like this :

Private Sub Form_Current()
Me.Refresh
End Sub

and saved.
Then opened the main form containing the subform this field is located and no check mark in O/P recovered for $0.00 of OPBalanceDue field.
Still stumped...