Using Check boxes

[RichFost]

Hi,

I have a form in an access97 database which users of the database would go into to update data.

I want to put a check box into the form so that the user cannot click on the update button in my form until they have ticked the check box.

I don't know whether I can set it to disable the update button until the check box is ticked, or whether I can set it to hide the update button until the check box is ticked; either solution would work for me.

Can anyone help ?

Thanks.

 

[Corticus]

Hi RichFost,

Assuming 'Chk1' for your checkbox name, and 'Cmd1' for your button, the following:

Private Sub chk1_Click()

cmd1.Enabled = chk1.Value

End Sub

will enable/disable the button depending on whether or not the checkbox is checked.

You could use:

Private Sub chk1_Click()

cmd1.Visible = chk1.Value

End Sub

to make the button invisible/visible.

Hope this helps,