checkbox

[krishnanhemanth]

hi
i have tried everything to set my checkbox value based on a textbox value
i have tried..
on form current
on form load
on textbox afterupdate
on checkbox on got focus

iam lost

where am i going wrong
the code i used is...
if me.totalqty = me.qty then
me.chkbox1.value = true
else
me.chkbox1.value = false
end if

qty is bound to a table
totalqty is unbound textbox and is a calculated textbox getting its value thru dsum
checkbox1 is bound to a table

the forms recorsource is from a query
all the data displayed on the form is from the query
please help

 

[Galaxiom]

What happens. Nothing at all or an error message?

 

[krishnanhemanth]

absolutely nothing

 

[HAMMAMABUARQOUB]

maybe the query is not updatable or...
the .Value property is used to display the current stat of the Checkbox not change it.
so you need first to check if you used the Yes/No field to "True/False" not leav it as Yes/No ... then check your query...