My form has a combo box that allows selection of a LocationID for an event from a Location table. The location list expands, but clicking one of the choices does not collapse the list or select the choice clicked as the field value. I do not know why; a combo box that selects the instructor is working.
The form data source query:
Code:
SELECT tblClassSession.ClassEventID, tblClassSession.ClassID, tblClassSession.InstructorID, tblClassSession.SessionDate, tblClass.ClassName, [LastName] & ", " & [FirstName] AS InstructorName, tblLocation.LocationID, tblLocation.LocationName
FROM tblLocation
INNER JOIN (tblClass
INNER JOIN (qryInstructors
RIGHT JOIN tblClassSession
ON qryInstructors.StudentID = tblClassSession.InstructorID)
ON tblClass.ClassID = tblClassSession.ClassID)
ON tblLocation.LocationID = tblClassSession.LocationID
ORDER BY tblClass.ClassName;
LocationID field source query:
Code:
SELECT tblLocation.LocationID, tblLocation.LocationName
FROM tblLocation;