View Full Version : Help with writing code, Please?


GC1
03-06-2002, 03:16 PM
I would like the form to open and all that is visible to the user is a single checkbox (checked).
If I un-check the box, I need a field to appear.
If I check the box again, the field should disappear and it's contents gone.

The name of the checkbox is "No Issues."

The field that I need to appear is "Issues."

Thank you to whoever can help.

Jack Cowley
03-06-2002, 05:46 PM
Set the Fields Visible property to No. Set the checkbox Default Value to True. In the After Update event of the Checkbox use this code:

If Me![No Issues] = 0 Then
Me![Issues].Visible = True
Else
Me![Issues].Visible = False
End if

Put the same code in the On Current event so the Issues field will be visible or not depending on the state of the checkbox.