Placing the IIf statement in the property sheet was incorrect.
As the code needs to be used in both the form current event (so it is checked on each record change) & in the after update event of both textboxes, I've added a procedure called CheckControls which is then called from each of those places. The code is:
Code:
Option Compare DatabaseOption Explicit
Private Sub CheckControls()
If Nz(WorkWhereSeen, "") = "" Then
cmdViewWorksWhereSeen.Visible = False
Else
cmdViewWorksWhereSeen.Visible = True
End If
If Nz(WorkPermHome, "") = "" Then
cmdViewWorksPermHome.Visible = False
Else
cmdViewWorksPermHome.Visible = True
End If
End Sub
Private Sub Form_Current()
CheckControls
End Sub
Private Sub WorkPermHome_AfterUpdate()
CheckControls
End Sub
Private Sub WorkWebPage_AfterUpdate()
CheckControls
End Sub
See attached for the updated version of your app