I gave a Continuous Subform with a Combo box Cbo1 and a CheckBox Chk1
Both are bound controls. The DoubleClick on the Combo box changes the record.
If Chk1 is set to False, I want the Combo box to work in the normal way.
If Chk1 is set to True, I want to stop the Combo box displaying anything other than the data already showing. (In other words - No Dropdown)
If I lock the ComboBox, it prevents the data changing.
If using Conditional Formatting I use the Enabled = false, it stops the "Drop down" working which is what I want, but also but prevents the Double click from working.
Is there a way round this dichotomy?
Thanks
Phil