Hi i am sure this is a easy question for you guys
I need a [Location] control on a form when = "First*"or"Arriva*" set [Invoiced] on the sameform to visible
this is the code i am trying
Private Sub Location_BeforeUpdate(Cancel As Integer)
If Me.Location.Value = "First*" or "Arriva*" Then
Me.Invoiced.Visible = True
Else: Me.Invoiced.Visible = False
End If
End Sub
any help will be greatly appreciated
I need a [Location] control on a form when = "First*"or"Arriva*" set [Invoiced] on the sameform to visible
this is the code i am trying
Private Sub Location_BeforeUpdate(Cancel As Integer)
If Me.Location.Value = "First*" or "Arriva*" Then
Me.Invoiced.Visible = True
Else: Me.Invoiced.Visible = False
End If
End Sub
any help will be greatly appreciated