Dear experts,
Appreciate if you could help me with the following issue I'm stuck with.
I have a continuous form EmployeeDashboardF.
On the form I would like to display a label with a colored dot basis the content of the text box EmployeeStatus.
I have following 4 labels:
show lblblack if EmployeeStatus is no longer employed
show lblgreen if EmployeeStatus is active
show lblred if EmployeeStatus is absent
show lblorange if EmployeeStatus is joining or leaving
Entered following code per label/status but can't get it to work.
Below the code for lblgree having status active.
Thanks for your help.
Best regards,
Siegfried
Appreciate if you could help me with the following issue I'm stuck with.
I have a continuous form EmployeeDashboardF.
On the form I would like to display a label with a colored dot basis the content of the text box EmployeeStatus.
I have following 4 labels:
show lblblack if EmployeeStatus is no longer employed
show lblgreen if EmployeeStatus is active
show lblred if EmployeeStatus is absent
show lblorange if EmployeeStatus is joining or leaving
Entered following code per label/status but can't get it to work.
Below the code for lblgree having status active.
Code:
Private Sub Form_AfterUpdate()
If Me!EmployeeStatus.Value = "active" Then
Me!lblgreen.Visible = True
Else
Me!lblgreen.Visible = False
End If
End Sub
Private Sub Form_AfterUpdate()
If Me!EmployeeStatus.Value = "active" Then
Me!lblgreen.Visible = True
Else
Me!lblgreen.Visible = False
End If
End Sub
Thanks for your help.
Best regards,
Siegfried
Last edited by a moderator: