UnDim Control box if other control =YES

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I need to enable a control if the user selects yes in
check box of another control.

Thanks in advance
Wayne
 
If Me!SomeCheckBox = True then
Me!SomeOtherControl.Enabled = True
Else
Me!SomeOtherControl.Enabled = False
Endif

Ron
 
In the AfterUpdate event of the check box try something like:

Me.NameOfOtherControl.Enabled = Me.NameOfCheckBox.Value

This will enable the other control if the checkbox is true (checked) and
disable it if the checkbox is false (not checked). Make sure that the
checkbox can't have a Null value for this to work. If it can, you can do the
above with an If statement instead

If Me.NameOfCheckbox = True Then
Me.NameOfOtherControl.Enabled = True
Else
Me.NameOfOtherControl.Enabled = False
End If

If the value of the checkbox is to be remember (i.e. it is bound to a field
in the underlying table) then you will also need to place the above code in
the form's Current event.
 
Thx Ron
It works great.
Wayne


-----Original Message-----
If Me!SomeCheckBox = True then
Me!SomeOtherControl.Enabled = True
Else
Me!SomeOtherControl.Enabled = False
Endif

Ron


.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

msg box - remove check box or keep check box in form 1
text box select text 1
Check Box - Need "Yes" value to return 1 to linked table 1
formating an unbound text box 1
Disable a checkbox 2
How to refer to the label of a subform control 3
Hiding Control BAsed on Check Box 4
How to Undimm Bullet after it is dimmed? 1

Back
Top