Question Enable Checkbox - reg

[Shallo9]

Hello All,

I have a combo box and a 3 checkboxes in a data sheet view form.

I'd like to enable or disable one or more checkboxes depending upon the value of the combo box for that particular record.

Unfortunately Conditional formatting cannot be applied to a checkbox (atleast not that I know of). Is there a way to accomplish this.

Any Help will be appreciated.

Many Thanks

 

[DavidAtWork]

If you're using a datasheet view I don't think you can because all records are visible and there's no way of trapping each record.
The only thing I can suggest is you switch the form to single record and now you can format the controls on your form using the OnCurrent event
David