Check box "click" to new record

[Wayne Cramer]

I have a form where the users view many fields but can only edit a check box - click to check. The problem is that the last check box clicked shows checked but the record is still in edit mode, so the operators open the report showing all records except the last one checked (clicked). Is there a mouse click event that will automatically go to the next record when the check box is clicked thereby taking the last record changed out of edit mode automatically?

 

[rainman89]

in the on click event of your checkbox you can simply move to a new record by using

DoCmd.GoToRecord , , acNext

 

[CEH]

Sounds like you might be better using a "Refresh" or "Requery" instead of moving to a new record... Seems it would get confusing to a user having a record change anytime a checkbox is checked.... OR unchecked.