CreganTur
07-29-2008, 01:36 PM
I've got an option group that contains 2 option (radio) buttons: optApproved and optDenied.
When the form containing this option group first opens, both option buttons are greyed out(see image below), since no selection has been made- I'm perfectly fine with this. When the user finishes with the current record on the form, they click a "Next Account" button that uses 'DoCmd.GoToRecord , , acNext' to move to the next record.
Now, I want to know how to grey out the option buttons right after the User moves to the next record (they can only move via the "Next Record" button). The reason for this is due to the fact that the selected option button stays selected when the form moves to the next record. I want to accomplish this so the User can't accidentally move to the next record without selecting an option.
I tried assigning a value to the option button, like I would for a checkbox:
Me.CheckBoxName = True '<<<Make box checked
Me.CheckBoxName = False '<<<Make box unchecked
but this threw an error that stated "You cannot assign a value to this object," which kills that idea :mkay
Any ideas? :dunno
When the form containing this option group first opens, both option buttons are greyed out(see image below), since no selection has been made- I'm perfectly fine with this. When the user finishes with the current record on the form, they click a "Next Account" button that uses 'DoCmd.GoToRecord , , acNext' to move to the next record.
Now, I want to know how to grey out the option buttons right after the User moves to the next record (they can only move via the "Next Record" button). The reason for this is due to the fact that the selected option button stays selected when the form moves to the next record. I want to accomplish this so the User can't accidentally move to the next record without selecting an option.
I tried assigning a value to the option button, like I would for a checkbox:
Me.CheckBoxName = True '<<<Make box checked
Me.CheckBoxName = False '<<<Make box unchecked
but this threw an error that stated "You cannot assign a value to this object," which kills that idea :mkay
Any ideas? :dunno