checkbox goes True but after reopening the form, its false

[Lightlancer]

when i click the button, the checkbox goes True,
when i close the form and reopen it, the checkbox is False again,
it should be True,
its like the record in the table is blocked or something but it isnt.

am i doing something wrong???

 

[JBinQLD]

Ideas/checks
what is it's status in the table before and after your operation? What's it's value in table after closing the form? This should isolate whether the change is ever being committed. If it is and being reset to false on open then there must be an on open event the resets it, or the control isn't bound correctly or you're seeing a different record

JB

 

[Lightlancer]

after clicking IN, the form will update the checkbox but nothing is going to happen in the table, it must go to True but it stays on False (before operation its False)
also when i DONT open the form and open the table, its still False.........
i also tried to delete and readd the checkbox to bound them correctly but still no go.

 

[JBinQLD]

What happens if you manually check the box and exit? is he result stored at table level then?

 

[Lightlancer]

then also it wont work, the table stays empty
and also the table stays empty........

 

[Lightlancer]

im using an tab control element (hoping to translate it right.....) and in the tab there are the checkboxes, maybe thats the problem??? if yes, how to solve that......

 

[JBinQLD]

Does the table you're binding these check boxes to have any data in? Do you have to create a record first? What is the mode of the form? is it set to allow edits? It reay sounds as though the control isn't bound....

JB

 

[Lightlancer]

the form is bound to tblstatus, wich is the table with all checkboxes, and yes i need to create the first record first and the form needs to change that record all the time, so in this table there will be only 1 record. the checkboxes are bound to tblstatus, and then the fieldname offcourse......

Data input is off and the rest is on, so edits is also on.
and I also agree its sounds as the control isnt bound, maybe to try outside the tab??

 

[PHV]

If DataEntry is false and the bound table is empty then your form will never works ...
I'd simply create the record for the 1st time directly in the table view.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lightlancer]

thats it , there is already a record in the table but i solved it by receating tje vorm and then it worked