CODEWITHSUNDEEP
sqlvbams-accesstextboxcontinuous-forms
designspeaks
designspeaks

Reputation: 91

Form Header textbox value changes with record set when scrolling through continuous form? in Access

I'm trying to set up a Continuous form in Access that provides information for an employee task list (i.e. Supervisor name, Employee name, Due date, Status, etc.).

In the form header, the supervisor name is displayed in a text box with tasks listed in the details section. When scrolling through the tasks listed in the details, I'd like the textbox displaying the Supervisor name to change when reaching the employees/tasks for the next supervisor.

(The SQL query pulls in all active tasks, regardless of the listed supervisor, and displays each record as a continuous form in alphabetical order by Supervisor)

SQL Code for query:

SELECT [tblAssociate_1].[FirstName] & ' ' & [tblAssociate_1].[LastName] AS SuperName,
       tblAssignments.CompletedDate, [tblAssociate].[FirstName] & ' ' & [tblAssociate].[LastName] 
       AS EmpName, tblAssignments.AssignmentID, tblAssignments.AssocID, tblAssignments.CreatedDate, 
       tblAssignments.CreatedBy, tblAssignments.Inactive, tblAssignments.InactiveDate,
       tblAssignments.InactiveReasonID, tblAssignments.ExpirationDate, tblAssignments.AssignmentTypeID 

FROM (tblAssignments LEFT JOIN tblAssociate ON tblAssignments.AssocID = tblAssociate.AssocID) 

LEFT JOIN tblAssociate AS tblAssociate_1 ON tblAssignments.SuperID = tblAssociate_1.AssocID 

GROUP BY [tblAssociate_1].[FirstName] & ' ' & [tblAssociate_1].[LastName], tblAssignments.CompletedDate, 
         [tblAssociate].[FirstName] & ' ' & [tblAssociate].[LastName], tblAssignments.AssignmentID, 
         tblAssignments.AssocID, tblAssignments.CreatedDate, tblAssignments.CreatedBy,
         tblAssignments.Inactive, tblAssignments.InactiveDate, tblAssignments.InactiveReasonID, 
         tblAssignments.ExpirationDate, tblAssignments.AssignmentTypeID   
HAVING tblAssignments.Inactive = False AND tblAssignments.ExpirationDate >= Date();

Currently, the textbox value will change when clicking on the a record in the details section.

Upvotes: 0

Views: 61

Answers (0)

Related Questions