CheckBox OnClick event doesn't activate

[RobTsintas]

Hi,

I have a form that is based on a non-updatable recordset, and has a number of checkboxes.

As the recordset cannot be updated just by clicking on the checkboxes, I have used VBA to run a line of SQL, which checks/unchecks the check box and refreshes the form.

This works fine if the VBA is in the OnClick event of a button, but if I put it into the OnClick event of the checkbox itself, it doesn't run the code (I just get the "This recordset is not updatable" message).

I tried putting the code into the GotFocus event of the CheckBox, but this causes problems with reloading the form.

Is there any way I can get the OnClick event to fire?

Thanks

 

[Remou]

I guess you could try On Mouse Down.

 

[RoyVidar]

It is probably because the checkbox is bound to a yes/no field in the recordsource in the non updateable recordset. When clicking it, it attempts to change the value in the field it's bound to, creating the errormessage.

If you wish to continue this, you will probably either need to unbind all the checbox controls, or use an updateable recordset.

Roy-Vidar

 

[RobTsintas]

Thanks for the suggestions. Will keep trying!

I need the checkboxes to display the current values, so they need to be bound to something. I might try replacing them with textboxes with some wingding tick/crosses and see if that helps.