Page 1 of 2 12 LastLast
Results 1 to 15 of 21

Combo Box that doesn't allow selection

  1. #1
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59

    Combo Box that doesn't allow selection

    Still on that training database, my enrollment form has a combo box for selecting the class session. The query that populates the combo box has three columns, and column 1 is the bound column.

    My problem is that while I can click the arrow and see the list of results, I can't click one of them to change the value of the combo box. It defaults to one when the page opens (SessionID = 27, incidentally), and it won't change the selected item.

    Anyone familiar with this problem?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    It sounds like either the form or the combo is locked or the form is read-only.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    Quote Originally Posted by pbaldy View Post
    It sounds like either the form or the combo is locked or the form is read-only.
    The combo box properties are "Enabled=Yes" and "Locked=No".
    The form shouldn't be read-only. I don't see any form properties that indicating that it is.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    What is the Allow Edits property of the form?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  5. #5
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    Quote Originally Posted by pbaldy View Post
    What is the Allow Edits property of the form?
    Allow Edits = Yes

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    Can you post the db here?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  7. #7
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    Quote Originally Posted by pbaldy View Post
    Can you post the db here?
    hrm... tricky

    a) it's a split database
    b) it contains employee information that I wouldn't be comfortable sharing

    I'll see about making a duplicate and scrubbing the data.

  8. #8
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    I attempted to upload scrubbed versions of the database files...

    Upload Errors
    Training.accdb:
    Invalid File
    Training_be.accdb:
    Invalid File


    The upload routine apparently doesn't allow .accdb files.

  9. #9
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    Your instincts are good; we definitely don't want any personal data posted. If you can carve out that form and whatever table(s) it depends on, with no personal data, that should be enough. It's just sometimes easier to figure out a problem when you can put your hands on it.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  10. #10
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    I think the file has to be zipped.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  11. #11
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    Quote Originally Posted by pbaldy View Post
    I think the file has to be zipped.
    You are correct, I see.
    Attached Files Attached Files

  12. #12
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    "Mass Enrollment" is the form I've been working on.

  13. #13
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    Ah; the problem is you're trying to edit an autonumber field. On my PC I actually get a message to that effect in the lower left corner of the form.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  14. #14
    Ted C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    59
    Quote Originally Posted by pbaldy View Post
    Ah; the problem is you're trying to edit an autonumber field. On my PC I actually get a message to that effect in the lower left corner of the form.
    Hmmm... I don't want to modify it, I just want to select it. I'm guessing I should point it at some other field?

  15. #15
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    11,883
    If you're trying to use that as a record finder, try the combo box wizard, choosing the third option, "Find a record...". It will create it for you (the combo will not be bound to the underlying data).

    Or, if that's supposed to select the session (and I'm just glancing at the data), perhaps it should be bound to the DClassEventID field in tblClassAttendance or some other table?

    Obviously I'm not clear on what you're trying to accomplish.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change to selection in combo box
    By corystemp in forum Access
    Replies: 7
    Last Post: 06-28-2010, 09:20 AM
  2. Combo Box field selection help needed
    By techexpressinc in forum Forms
    Replies: 8
    Last Post: 04-01-2010, 08:42 AM
  3. Checking List Box Value with Combo box selection
    By empyrean in forum Programming
    Replies: 1
    Last Post: 10-23-2009, 05:01 PM
  4. Replies: 1
    Last Post: 08-26-2009, 09:45 AM
  5. Replies: 3
    Last Post: 02-26-2009, 08:17 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
  •  
Tech Forums: Microsoft Office Forums