G
Guest
I have an invoice form that has text box's serialNumber, prefix, and part
number. (All Are Text)
On a specific line if the prefix is "QGS" I want only that line to allow
serialNumber to be visible. I changed the property of serialNumber to
visible = false and added code as follows;
Private Sub SerialNumber_AfterUpdate()
If Me.PrefixID = "QGS" Then
Me.SerialNumber.Visible = True
End If
End Sub
When I do that, the whole column becomes visible for serialNumber whether
or not prefixID is or is not = to "QGS"
number. (All Are Text)
On a specific line if the prefix is "QGS" I want only that line to allow
serialNumber to be visible. I changed the property of serialNumber to
visible = false and added code as follows;
Private Sub SerialNumber_AfterUpdate()
If Me.PrefixID = "QGS" Then
Me.SerialNumber.Visible = True
End If
End Sub
When I do that, the whole column becomes visible for serialNumber whether
or not prefixID is or is not = to "QGS"