Check Boxes

[HL]

Help Needed!

I wonder if anyone could point me in the right direction?

I am using Access 2000 and I am trying to achieve this task

I have a Check box on my form and when the check boxed is clicked it will make a command button become visible. If I remove the tick from the check box the button will not be visible.

I understand that I am going to have to write some code, but what do I put????

Cheers HL.

 

[aqif]

Hi

On After Update event of check box (Chk1) just write

If Me.Chk1 = -1 Then 'if check is yes
Me.Cmdbtn1.Enabled = True
ElseIf Me.Chk1 = 0 Then ' if check is no
Me.Cmdbtn1.Enabled = False
End If

 

[Rich]

Form Current
If Me.CheckBoxName=True Then
Me.CommandName.Visible=True
Else
Me.CommandName.Visible=False
End If

Check Box After Update
Form_Current

HTH

 

[aqif]

OOOps....i though u wanted enable disable function....anyhow HTH function is also write....n u can also use visible=true in my code

Cheers!
Aqif

 

[iantaylor]

Hello.
I am also trying to make a option visiable by changing it to enabled.
I used the example below and it hasn't worked.

I'm using Access 2000 if that makes a difference.

I don't have much knowledge on Access so the more info the better.

Thanks
Ian