check boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 check boxes in a frame. I'm having trouble with finding out which
one is checked.

When the form opens, chkbox1 is the default and it is checked. If the user
selects one of the other choices, how do I programm it to find out which one
is checked?

Thanks again for all of the help.........
 
if all checkboxes in a frame, and it is allowed to have only one checkbox
cheked - then frame control will return a value of checked checkbox. Just
set to each checkbox a unique value
 
I have 3 check boxes in a frame. I'm having trouble with finding out which
one is checked.

When the form opens, chkbox1 is the default and it is checked. If the user
selects one of the other choices, how do I programm it to find out which one
is checked?

Thanks again for all of the help.........
Click to expand...

Re: I have 3 check boxes in a frame...
By "Frame" do you mean an Option Group?
The the value of the option group is the value of whatever box was
selected.

If Me!OptionGroupName = 1 Then
' Box 1 was checked
ElseIf Me!OptionGroupName = 2 Then
'Box 2 was checked
Else
'Box 3 was checked.
End If
 
JT,
I would use Select Case.
So in this example I will assume the name of your check box Option group is
fraCheckBoxes so you would code it like this:

Select Case fraCheckBoxes
Case Is = 1
'Do this
Case Is = 2
'Do that
Case Is = 3
'Do It
End Select

Also Note I am assuming that you created your checkboxes within an option
group or have assigned them to an option group. Take Care & God Bless ~
SPARKER ~
 
Back
Top