Row Source of the list box is:
SELECT tblLeaveDetail.Shift, tblLeaveDetail.District, tblLeaveDetail.Employee_ID as Star, [tblLeaveDetail.Last] & ', ' & [tblLeaveDetail.First] as Deputy, tblLeaveCode.Type, tblLeaveDetail.Hours, tblLeaveDetail.Remarks FROM tblLeaveCode INNER JOIN tblLeaveDetail...