Hide or show control when form opens 2

[ad2]

Hi,

When a form opens and the subject id field is blank, I want a command button to be hidden. If the subject id is filled in I want the button to show. The code I have below is not working - the button is visible if the subject id is blank or is filled in. Any ideas?

Thanks,
Ad2


'Private Sub Form_Load()
' If IsNull(SubID) Then
' cmdReport.Visible = False
' Else
' cmdReport.Visible = True
' End If
'End Sub

 

[skyline666]

(Note this isn't anything to do with an answer to your question, its already answered anyway!)

Just a little info when your posting, use [ignore]

[/ignore] to start writing code, and [ignore]

[/ignore] to finish the code. An example:

[ignore]

Private Sub Form_Load()
    If IsNull(SubID) Then
     cmdReport.Visible = False
    Else
     cmdReport.Visible = True
    End If
End Sub

[/ignore]

will look like this:

Private Sub Form_Load()
    If IsNull(SubID) Then
     cmdReport.Visible = False
    Else
     cmdReport.Visible = True
    End If
End Sub

This makes it easier for people to see/copy code, and also stops confusion especially as you used comments (') to show your code.

Andrew