Results 1 to 7 of 7
  1. #1
    pmac is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12

    Row source values not appearing in Form


    Alright here is my problem. I have a combo box and have value list as my row source type(I know, not the best option, I didn't design it). So my row source is a list of over 20 options. When I try to add another row source value, it does not appear on the form. Is there any way possible for me to get this to work? I understand that creating a table and using that might be my best option for my row sources, but I was just wondering if there was any way around this problem...

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    You'll have to copy the value list to the combo box's row source property.

  3. #3
    pmac is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12
    hmmm.. I have the value list selected in properties as Row Source Type, and the row source is my list of values separated by a semicolon. I'm not really sure what you mean by copy the value list to row source properties?

    btw I'm using access 2007

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    So you added this value to the row source of the combo box on the form? The way it sounded is that you had a lookup field set at table level and added the value there but not on the form.

  5. #5
    pmac is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12
    yes I added the desired value to the row source property. I have my form display an empty combo box and when its clicked, all the values from the row source property should be displayed. However, when I added two new ones the other day, they do not show up like the rest of the values.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    You said you didn't design it -- so is it possible that there is some other code that is altering the Value List? I have Acc2003 and just tried a combo with a value list. Opened the form, and even under properties added values to the list, and they show up. Close form save change and reopen and everything is fine. So I'm thinking that maybe there is code that is resetting/assigning the Value list...but maybe not????

  7. #7
    pmac is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12
    Yeah I'm searching through some code but not finding anything. I can make this work on my master database by selecting Allow Value list edits: Yes, but the client db's don't seem to update.

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

Similar Threads

  1. Access command appearing in Word
    By CrankyOldGuy in forum Access
    Replies: 0
    Last Post: 01-11-2011, 11:09 AM
  2. Replies: 5
    Last Post: 08-13-2010, 07:26 PM
  3. Replies: 3
    Last Post: 04-04-2010, 05:26 PM
  4. screen tip on ribbon button appearing
    By genesis in forum Access
    Replies: 0
    Last Post: 11-14-2009, 01:41 AM
  5. Control source and calculated values
    By meistersteff in forum Forms
    Replies: 0
    Last Post: 11-23-2007, 07:04 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