Button visible based on checkbox

[barra47]

On a form I have a button named NCR

and a check box named "View"
On opening the form
if the checkbox "View" is equal to -1 then button "NCR" is visible
if = 0 then not visible

How do I write this code up

what I have so far is not working

Private Sub Form_Open(Cancel As Integer)
If View = -1 Then Me.NCR.Visible = True
End Sub

Thanks in advance

 

[PHV]

Use the Load event procedure instead of the Open:
Me!NCR.Visible = Me!View

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886