How to enable radio buttons in a form opened as read-only ?
Posted on 2014-04-11
I have an Access 2007 app with various forms which some users use for data maintenance. I now want to make it available to read-only users, so I open the forms in the app in normal or read-only mode depending on the user. So far so good.
However, on one form I am using a battery of radio buttons to allow the user to select subsets of the data (filter function, but programmed through VBA, as many of these filters can be combined). Now there radio buttons are disabled in read-only mode, and enabling them through code in the forms load event doesn't work. So the read-only users won't be able to filter, which is no good.
Is there a way I can keep the basic read-only feature but have my radio buttons to work ? Or do I have to change the radio buttons to pushbuttons, as these work in read-only mode ?