Results 1 to 6 of 6
  1. #1
    gsainz is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3

    Combo Box - not allowing user to select from the drop down in Form View

    I created two combo boxes in an Access Form. I want to be able to select a specific ID to go to that record, but the form won't allow me to select the ID. I can see all the ID numbers, I just can't select them.


    Also, I am trying to make a Yes/No drop down menu that will populate a yes answer in the Table. It shows "True", "Yes", and "No". I only want it to say "Yes" and "No", and this field isn't allowing me to select one of those options either.
    Please help!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Use the ComboBox wizard to create a new cbo and select the 3rd item.

  3. #3
    gsainz is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3
    It is giving me the wrong info. I attached a screen shot:Click image for larger version. 

Name:	Untitled.jpg 
Views:	8 
Size:	17.7 KB 
ID:	11651

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Show property settings for each combobox.

    RowSource
    ColumnCount
    ColumnWidths
    BoundColumn
    ControlSource
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    gsainz is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3
    Click image for larger version. 

Name:	Untitled2.jpg 
Views:	6 
Size:	174.3 KB 
ID:	11653here it is, thanks

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Does not show the RowSource statement.

    A assume that is for the ID numbers?

    What about the Yes/No combobox properties?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Combo Box not allowing selection
    By libraccess in forum Forms
    Replies: 2
    Last Post: 02-03-2013, 01:48 AM
  2. Help with allowing administrator access using user name
    By BiotechJen in forum Programming
    Replies: 4
    Last Post: 01-30-2013, 11:02 AM
  3. Replies: 6
    Last Post: 08-07-2012, 02:44 PM
  4. Split Database only allowing single user access
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 11-08-2011, 11:12 PM
  5. Replies: 4
    Last Post: 09-11-2011, 01:29 PM

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