The multicolumn combobox doesn't display
The combo box named "cboStaff" has
1. column count 11
2. column width property set to as below:
0cm;3cm;0cm;0cm;0cm;0cm;0cm;0cm;0cm;0cm;3cm
3. The rowsource of a combobox is set to query "qryAccount" and it is as below:
My problem is that the last column "Stage" is showing blank in the combobox. WHen I run the query then there is data in that column but not sure why for all the records that column is blank???
ANy help will be much appreciated.
Thanks
The combo box named "cboStaff" has
1. column count 11
2. column width property set to as below:
0cm;3cm;0cm;0cm;0cm;0cm;0cm;0cm;0cm;0cm;3cm
3. The rowsource of a combobox is set to query "qryAccount" and it is as below:
Code:
SELECT tblstaff.[Staff Number], tblstaff.[Staff Name], tblstaff.[Start Date], tblStaffStage.[End Date], tblRole.[Role Title], tblLineManagerDetails.Current, tblstaff_1.[Staff Name], tblstaff.RoleID, tblstaff.strUser, IIf([tblStaff].[AuthorisedAgent]=True,"Yes","No") AS AuthPer, tblStages.Stage
FROM (tblstaff AS tblstaff_1 RIGHT JOIN ((tblRole RIGHT JOIN tblstaff ON tblRole.RoleID = tblstaff.RoleID) LEFT JOIN tblLineManagerDetails ON tblstaff.[Staff Number] = tblLineManagerDetails.[Staff Number]) ON tblstaff_1.[Staff Number] = tblLineManagerDetails.[Line Manager Staff Number]) INNER JOIN (tblStaffStage INNER JOIN tblStages ON tblStaffStage.StageID = tblStages.StageID) ON tblstaff.[Staff Number] = tblStaffStage.[Staff Number]
WHERE (((tblStaffStage.[End Date]) Is Null) AND ((tblLineManagerDetails.Current)=True))
ORDER BY tblstaff.[Staff Name];
My problem is that the last column "Stage" is showing blank in the combobox. WHen I run the query then there is data in that column but not sure why for all the records that column is blank???
ANy help will be much appreciated.
Thanks