checkbox again

[krishnanhemanth]

hi
i have asked several questions about checkbox previously
it goes like this...
a form with 2 textbox and one checkbox
textbox1 is called "QTY" bound to a table
textbox2 is called "GOTQTY" unbound but calculated getting its value from subform
checkbox is called "QTYSTATUS" bound to a table

I want the checkbox to change the status to "True" if "QTY" = "GOTQTY"
i have coded on the form current event...
if me.qty.value = me.gotqty.value then
me.qtystatus.value = true
else
me.qtystatus.value = false
THIS IS NOT WORKING...I TRIED WITH onformload and other events but no
the only way its working is by using the same code on the checkbox ONGETFOCUS event.
any help
thanks in advance
hemanth