Connecting Tech Pros Worldwide Forums | Help | Site Map

Help with check boxes!

Newbie
 
Join Date: Jun 2007
Posts: 1
#1: Jun 30 '07
I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

Thanks

pureenhanoi's Avatar
Familiar Sight
 
Join Date: Mar 2007
Location: VietNam
Posts: 175
#2: Jun 30 '07

re: Help with check boxes!


Quote:

Originally Posted by VBA Novice

I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

Thanks

there is no effect that u want. Do it by code
Put into ur form two checkboxes and named it: chkRight and chkLeft
Double click in chkRight to open code editor.
Write ur code like this
Expand|Select|Wrap|Line Numbers
  1. Private Sub chkRight_Click()
  2.      If chkRight.Value = 0 Then    'right-checkbox is off
  3.            chkLeft.Value = 0           'then check-off the left
  4.      End If
  5. End Sub
  6.  
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#3: Jun 30 '07

re: Help with check boxes!


Quote:

Originally Posted by VBA Novice

I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

Thanks

Before asking for code ,u need to post how u have tried to solve it.
Reply