Msg box problem

[miziri]

Hi
I have this below code
Dim bal, outp As Double
bal = CDbl(Me.cmbPro.Column(2))
outp = CDbl(Me.txtOutpot)
If bal < outp Then
MsgBox "Year Balance exceeded", vbOKOnly


End If

I have one note about warning MSGBOX
if I have monthly balance 100$ and I want to take output 101$ for sure it will give warning MSGBOX "Year Balance exceeded"
then I will correct from 101 into let say 80$ when i click on enter still that warning massage BOX appear
why that happen now that new value which 80$ is less.

Thanks

[Access_Blaster]

You need a Me.Requery in your controls after update event. I am guessing

Me.txtOutpot


Richard