Results 1 to 2 of 2
  1. #1
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    66

    non-selectable combo box


    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;

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    It sounds like either the combo is locked or the Allow Edits property of the form is No (or perhaps the form is bound to a non-updateable source).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-26-2009, 10:45 AM
  2. Replies: 3
    Last Post: 02-26-2009, 10:17 AM
  3. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  4. Date Selectable limitations
    By Robert_Clash in forum Access
    Replies: 0
    Last Post: 11-27-2007, 09:00 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums