Hello, I have a form that if I check a box it sets an supervisor as inactive and if unchecked it sets them as active. What I need to do is in my message I need to display the (EmployeesNames) that is associated with the supervisor (txtSupID) I’m trying to set active or inactive. I created a query (qryAssociatedEmpSup) that displays the list of (EmployeesNames) thatis associated with the (SupID).

Display like:

Are you sure you wish to change supervisors status to INACTIVE?"
If so then you have to adjust employees associated with this supervisor,
because thier name will not show up in any list untill you do."
Joe doe
Joe doe
Joe doe
ect


[CODE]If chkStatus = True Then
If vbYes =MsgBox("Are you sure you wish to change supervisors status toINACTIVE?" & vbCrLf & vbCrLf _

& "If so then you have to adjust employees associated with thissupervisor," & vbCrLf _
& "because thier name will not show up in any list untill youdo.", _
vbYesNo + vbQuestion, "Set to Active?") Then
Else
Me.chkStatus = False
Me.Requery
End If
Else

If chkStatus =False Then
IfMsgBox("Are you sure you want to change the supervisors status toACTIVE?", vbQuestion + vbYesNo, "Set to InActive?") = vbYes Then
Me.Requery
Else
Me.chkStatus = True
Me.Requery
End If
End If
End If
[/CODE]


SELECT [EmpFName] & " " & [EmpLName] AS EmployeesName, tblEmployees.SupID
FROM tblEmployees
WHERE (((tblEmployees.SupID)=[Forms].[frmEditSupervisors].[txtSupID]));