I've found one reason (not user error that is) why check boxes seem to be randomly unchecked: http://forums.nbn.org.uk/viewtopic.php?id=1154

Must be the way my system is set up... or perhaps I'm just super fast :cool:

One of the things on my do list is to display all non-checked records and check 'em - having had various "complaints" of missing records I tracked the problem down to suites of unchecked records (which had been entered years previously by someone else).

I wonder whether a dialog after inputting records saying "check these now!" or similar is worth considering?

Further to your point on why you would want to uncheck a record, is there a reason why unchecked records should exist in the database (aside from waiting to be checked)?

It makes sense to uncheck a record when any of the content has changed. So, if you go into edit mode, change something and uncheck it, then I think it should be accepted without prompt. But I agree, just unticking the tickbox without explicitly editing the record is an unusual thing to do so it should be accompanied by a confirmation prompt.

Best Wishes

We fairly often untick records to take them 'offline'. If someone informs to us that a record looks wrong, or we need to stop some records appearing in our reports for whatever reason, unticking them offers a convenient way of disabling the records until further notice. It's quicker and easier than creating an 'invalid' or 'requires confirmation' determination.