Check Box Question 1

[fredk]

I have a sub-form that holds associated data to the main form. There are about 15 check boxes with erros along with a check box that is to be selected if there are no errors.

I put some very basic code in the on click event of the save button - just two if statements that say if the checkbox for no errors is checked along with any of the other check boxes, provide a message box stating that you can't do this.

The problem is that if you click to another record on the main form, click the add button on the subform, etc... the incorrect data is still saved.

What is the best way to force the user to correct the data in the subform without moving on until the data is corrected?


Thanks!!!!

Fred

 

[Remou]

I think the easiest way is to disable the No Errors box when any other box is checked. And in the Before Update events of the other boxes, add a message box that says clicking this will cause the No Errors box to be unchecked and disabled. Or there abouts.

 

[fredk]

That would work - thanks!!!!


Fred