unbound option group in bound form - unchangable?

[ParanoidAndroid]

Hello comrades.

I'm using Access 2002.

I have created a form that is bound to a table. On this form I would like to create a group of radio buttons that affect the way the form is displayed, but do not update the bound table in any way.

My problem is: When I create the option group I am unable to change the selected option.

Is it possible to have an unbound option group in a bound form?

Many thanks in advance.

 

[missinglinq]

Yes, you certainly can have an unbound Option Group on a bound form! The Selection will be the same for every record, in the way of all unbound controls, but given your usage here, that shouldn't be a problem. What code do you have behind the Option Group? I suspect that's more apt to be causing the problem.

 

[gemma-the-husky]

but note that the code for the before update/after update in the option group is found in the FRAME of the group

each button has a value, and (normally in the after update event) you can using a select case to process the selection

 

[ParanoidAndroid]

I found my problem... My form was set to "Allow Additions" only... which stops you from changing the option group (even though it is not bound to the table!)

I need to "Allow Edits" and then the form works as planned... so I now need to work around the problem of someone being able to change the data.

Thanks for the answers comrades!

 

[gemma-the-husky]

set the controls other than the option group to

enabled = true
locked = true

that will prevent manually editing

you can lasso them all, or shift-click to select multiple controls, and do them all at once