Results 1 to 5 of 5
  1. #1
    AnnWalls is offline Novice
    Windows XP Access 2007
    Join Date
    May 2014
    Posts
    2

    Combo Box Options


    I have added some combo boxes to my form. In the row source line, I added the options I would like to use. However, after I save the form, and try to input data; these options are not in the combo box. What am I doing wrong?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Check the columns property, put the table ID as 0' length, then whatever length for the other fields in the row source

    I usually have ID and Description fields

    so cats table

    ID CatName
    1 Garfield
    2 Felix
    3 Mittens


    so column one in your columns should be 0 (because you want to have id field, just not view it)

    then say 6 for the next column.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Column Widths and Column Count properties for the combobox

  4. #4
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by ItsMe View Post
    Column Widths and Column Count properties for the combobox
    go with what ItsMe just suggested. (Go with anything ItsMe says )

  5. #5
    AnnWalls is offline Novice
    Windows XP Access 2007
    Join Date
    May 2014
    Posts
    2
    Thanks so much for your help. I actually found that when I changed the Row Source Type to Value List, it worked. My data base was originated in an earlier version and the things that worked in that version are different then what works now...

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

Similar Threads

  1. Replies: 3
    Last Post: 07-14-2013, 09:16 PM
  2. yes or no options
    By madhu in forum Access
    Replies: 3
    Last Post: 04-18-2013, 07:31 AM
  3. Filtering options using Cascading Combo boxes
    By Lincoln in forum Database Design
    Replies: 3
    Last Post: 07-15-2011, 08:25 PM
  4. Networking Options
    By Robertag in forum Access
    Replies: 1
    Last Post: 03-13-2011, 01:16 PM
  5. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 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