Hi,
Can someone please help? I have never seen this happening before:
I have a combo box on a form whose source is the following query:
SELECT [tblEmployees].[EmpNumber], [tblEmployees].[Surname]
FROM tblEmployees LEFT JOIN tblLaserscanmessungen_test ON
[tblEmployees].[EmpNumber]=[tblJobs].[EmpNumber]
WHERE ((Not ([tblJobs].[EmpNumber]) Is Null) And (Not
([tblMeasurementsType1].[BodySize]) Is Null And Not
([tblMeasurementsType1].[BodySize])=IsEmpty([BodySize])))
ORDER BY [tblEmployees].[EmpNumber] DESC;
What is happening here is that I display a list of Employees as
follows:
EmpNumber Surname
--------- --------
615 Smith
616 Jones
617 Smith
618 Brown
When I click on the combobox dropdown arrow, the above list displays
correctly. The value that is displayed in the combo box when I click
one of the entries is ONLY the EmpNumber.
The problem is e.g. when I select "615 Smith" (where there are more
than one "Smith" but they have unique EmpNumber's) then after clicking,
the value displayed automatically changes to "617".
I cannot figure out why this is happening, anybody?
Regards,
Jean