Option Group-Where Is Value Stored?

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Using A02 on XP. Have avoided option groups for a long
time but now find I need to use one. I have a Yes/No field
to indicate whether an extention was requested. When it is
checked, the ExtensionDue field will calculate the new due
date. Now, I have to indicate between 2 types of
extensions (Corp or Gov). I created an option group with
two buttons, Corp=1 and Gov=2. I told the wizard to
remember the value to use later. My problem is this: I
want the value now...where is it? Do I just use formulas
that use If Corp=1 or if Gov=2? Where is the If =1 this
and if =2 that control? I've checked my field list and
only see Corp and Gov. I read the manual and, of course,
in their example, they chose 'save value to this field'.

I know this is REALLY REALLY basic, but I've never been
here before and it can't be that difficult. Thanks in
advance for any advice or help!
 
Hi,
I assume you have your option buttons in a frame control?
The frame control will have a value corresponding to whichever option is
selected. So if you select Corp, your frame control will have the value 1.

In code:

If Me.yourFrameControl = 1 Then
'do something based on Corp being selected
Else
'do something based on Gov
End If

HTH
Dan Artuso, MVP
 
EXACTLY! Thanks bunches! I knew it was simple but didn't
see the frame as a control. I'll work on it. Thanks again
for the quick reply!
 
Back
Top