Option Button with Negated Value

[rohnds]

I have an option button on my main form. You click on the option button to display all the cars available. But in my table the available cars are stored "False".
Is there anyway, I can change the values of the option button such that they work the opposite.
For example, if I click on the option button, I want the value False instead of True and vice versa.

 

[John Big Booty]

Yes you can do this using codem but with out seeing your current code, it's hard to be any more specific than to say simply treat the result of a check check box in the opposite manner to what you would expect.

 

[rohnds]

How would you change the value of the option using vba such that the opposite value is stored.

I tried creating a flag and then changing the value of the option button using vba but it just doesn't work depending on the value of the flag.

 

[John Big Booty]

You don't need to change what's being stored just how you deal with it.

You've given us scant information to work with here, so as I said before it is hard to be specific.

 

[rohnds]

Here is what I want. I have option button. The default value is set during form load to "False". When the use clicks on the option, I want the option button to be set to False rather than True. When the user unelects, the option button should be set to "True" rather than False.

The reason for this that the option button is linked to field in a subform.

I have found a way around the problem by using a combo box with True and False as assigned values. But I just would like to know if you could create an option that work opposite to the normal.

 

[Poppa Smurf]

How many buttons do you have in your option group? As John requested would you please post your code or a sample of your database. It is a bit hard trying to give help with so little info.