Using Option Group to Filter Data

[Dick]

I have created an option group to filter data on my form. The option
group works great as long as the form is in edit mode. However, I want
to set the form to 'Allowedits = False' until the user clicks an edit
button. Since the form doesn't permit edits the option group doesn't
work. Any suggestions for making this work will be appreciated.
Thanks....

 

[Allen Browne]

You are correct: even if the option group is unbound, you can't use it if
the form's AllowEdits property is No.

Instead, set the Locked property of the other controls on the form. They
cannot be edited if they are locked, but the option group remains usable.

There's some code in this link that locks all the bound controls on the
form, leaving the unbound ones unlocked:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html