If then Visible Controls on Forms

[ccocom]

I am trying to make certain controls visible on a form for both "on current" and "after update" conditions. I started with this:

Private Sub Form_Current()
If Item = "Monitor" Or Item = "Printer" Or Item = "Telephone" Or Item = "Scanner" Or Item = "Workstation" Then
SerialNumber.Visible = True
Else
SerialNumber.Visible = False
End If
End Sub

This worked great. I then added this:

Private Sub Form_Current()
If Item = "Monitor" Or Item = "Printer" Or Item = "Telephone" Or Item = "Scanner" Or Item = "Workstation" Then
SerialNumber.Visible = True
Else
SerialNumber.Visible = False
End If
If Item = "Monitor" Then
MonitorSpecsID.Visible = True
Else
MonitorSpecsID.Visible = False
End If
End Sub

in an effort to make another field visible under a different condition. I received an error requesting an object. Not sure what to do next. Any ideas?

 

[Rich]

Try
Me.MonitorSpecsID.Visible

 

[pdx_man]

Please specify which line the error is on. I'm guessing that you have a mis-spell. Using Rich's suggestion of Me. would at least bring up the control names and ensure you are referencing a valid control on the form.

 

[ccocom]

Thanks. I hadn't renamed the control to match the control source name. A rookie mistake.

 

[ccocom]

Thanks. I hadn't renamed the control to match the control source name. A rookie mistake.