Check Box stays ticked

[K1Kingy]

I have a subform running in one of my forms which shows the following:

StudentID | BookTitle | DueDate | DateReturned | Return* |


The first 4 are straight out of my tbl_issue table. I added a check box on the end of that called Return. When i tick that it will set a return date, and update some other fields. that all works fine.

the problem is, when i check that box it stays check for every other book issue. is there any way that it can be checked for that specific book issue and then be unticked for the rest until i need to check them?

cheers kingy

 

[missinglinq]

You'll have to add a field to your tbl_issue table and bind the checkbox it. The value for an unbound control is the same for all records. This applies to textboxes, comboboxes as well as checkboxes.