Want to catch an optionbuttons value

[Jack Daniels]

Hi!
I have a db in Access 2003.
I have a form named frmStat with FirstDate and LastDate and five options
I want to use the values in a querry.
I can catch the Datevalue with [Forms]![frmStat]![FirstDate] and so on but how do I do to catch the value from the options button?

Jack

 

[RuralGuy]

You have to examine the OptionFrame.Value
[Forms]![frmStat]![OptionFrame]

 

[Jack Daniels]

Can´t get it work

Ok, I understand what you mean but I can´t get it work.

I try to use it in a querry like this, [Forms]![frmStat]![OptionFrame]
What I want is to get the numbers 1, 2, 3, 4 or 5 from the five different options that I have.

This results in nothing.... so how do I have to do?

Jack

 

[RuralGuy]

That should work *if* the name of your OptionFrame is actually OptionFrame. Usually Access assigns a number along with the name. Have you changed the name of the OptionFrame?

 

[Jack Daniels]

Thanks

It worked, I had made another mistake wihch interferred with that code, sorry.
Jack

 

[RuralGuy]

Excellent! Glad to hear you got it working.