Default (automatic) Click in Option Group

[waldemar]

How can I set a value in an option group by VBA?

I have a global variable that keeps the value of the option group. On entering the form I would like to read out this variable and let Access "click" on the according option button. Simply setting the value property does not seem to work (Me.optResults.Value = gValue)...

 

[hermanlaksko]

Try this
Me!optResults = gValue

I expect that gValue is a number

 

[VBslammer]

Option groups are contained within a frame, and the value used by access is the frame value:

Me![fraOptions] = gValue

Changing the value of the frame will automatically select the right item for you.

VBSlammer

 

[waldemar]

Oops Sorry, of course it works the other way as well.... was a problem with the global variable . Thanks anyway!