The trouble with CheckBoxes ...
Posted on 2011-10-20
... is that if you click on them the checkbox immediately toggles to the reverse value.
I have a Checkbox (BBReq) which allows the user to specify whether a particular Participant attending an Event requires Bed & Breakfast accomodation.
If the value in BBReq is True then data can be entered into the BBCost, BBCharge, BBExtras, BBQtyGuests, BBQtyNights, BBStartDate, BBEnSuiteReq, BBDisAccReq, BBQtySingle, BBQtyDouble, BBQtyTwin, BBQtyFamily, BBName and BBRef (i.e. quite a lot of data).
If the value in BBReq is False then none of these fields are available (locked) and are all empty of data.
So far no problem.
If BBReq on Form load is False and it is clicked then it goes to True and I unlock all the BB fields - agian this is no problem.
Here is the problem
If BBReq on form load is True and it is clicked then it goes to False and I want to cancel all the values in the BB fields ... BUT I want to warn the user that the data is about to be cleared and give them a chance to change their mind. I use a VBOKCancel msgbox to do this.
It all works but if the operation is cancelled the BBReq checkbox remains unchecked and the user may then worry that the Cancel has not worked (despite all the other fields having not been cleared of data).
Is there any way of resetting the BBReq CheckBox with a tick?