Option Group Values selection

[cherosoullis]

I have created an option group with two buttons (New, Used). In another text box I used a formula taking values true or false on option group. The formula is not working. It goes like this.

=IIf([radNew],[/U][/B]Null,IIf([radUsed],[/B]IIf([txtAgeofCar]<184,[txtExciseinTotal]=Null............

 

[ssteinke]

Option groups assign values to each radio button... look at the property menu 'data' tab to see the 'option value' for each option. In your scenario assuming NEW is value 1 and USED is value 2

=IIf(Me.optGroupName=1,Do Something, Do Something Else)

hope that helps,

Scott

 

[cherosoullis]

This realy work

Thanks very much for your responce