Hiding Fields with Check Box (1 Viewer)

stu_c · Aug 22, 2019

Hi all
I have got tick box that I want when ticked to unhide some fields?

The Tick box is called: Dispose and when this is ticked I want the field Disposel address etc. to be unhidden?

I have got it kind of working but when I go onto a new record then back to the previous one the record on the previous is hidden any pointers?

Code:

Private Sub Form_Current()
Me.DisposeAddress.Visible = False
End Sub
 
Private Sub DisposeCheck_AfterUpdate()
If Me.DisposeCheck = -1 Then
Me.DisposeAddress.Visible = True
End If
End Sub

thanks

pbaldy · Aug 22, 2019

You need an Else clause in both. More like:

http://www.baldyweb.com/ConditionalVisibility.htm

arnelgp · Aug 22, 2019

Code:

Private Sub Form_Current()
Me.DisposeAddress.Visible = Nz(Me.DisposeCheck, False)
End Sub
 
Private Sub DisposeCheck_AfterUpdate()
'same code as above
Call Form_Current
End Sub

Hiding Fields with Check Box (1 Viewer)

stu_c

Registered User.

pbaldy

Wino Moderator

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread