Results 1 to 8 of 8
  1. #1
    slochhaas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    4

    Add item to value list in list box - error

    I have a subform with a list box - value list type for the row source. I added a new option to the row source, using all the same formatting as what's already there to type it in.
    In the form view, I see my new option in the drop down. But I can't use it. Clicking on it just prompts a message that says "Select from Dropdown." I can't continue until I click one of the previous items in the list.


    I need to add this new item, any ideas?

    SOLVED: Ok, I feel dumb. There was a validation rule hidden in a linked table from another database. Had a hard time tracking it down because we have several tables/fields all using similar field names, etc. The new item I had added to the list box was not in the validation rule, hence it wasn't sticking. The "select from dropdown" popup was the validation text. AT LEAST I KNOW NOW.
    Last edited by slochhaas; 01-31-2017 at 05:10 PM. Reason: Solved

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Using a listbox to add to the listbox?
    if this is true, then you must refresh the list afterwards. Refresh all button on toolbar.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Maybe just delete the list box and redo it with the new value included.

  4. #4
    slochhaas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    4
    This is an old form I inherited. Don't want to lose previous data by deleting it. If that were an option, I'd just use a table instead of a value list.

  5. #5
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Data is not stored in the control itself, you would just need to include all the values and see if any events are triggered by the control to recreate them. So if you click one of the old values in the list it takes it, but just not your new value?

  6. #6
    slochhaas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    4
    >>So if you click one of the old values in the list it takes it, but just not your new value?

    This is correct. I was able to add the new thing to the list, it shows up, but can't use it in the form.

  7. #7
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    What are all the values in the list(which one is the new value)? Is the listbox bound to a field, if so what is it's datatype in the table?

  8. #8
    slochhaas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    4
    To clarify: I wasn't adding a new item to the list from the Form View. I was in Design View editing via the Property Sheet.
    I did try adding a new list item via the Form though -- it does the same thing. Adds to the list options in the drop down, but you can't select it in the form without getting a popup about selecting from the drop down.

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

Similar Threads

  1. Replies: 5
    Last Post: 07-29-2014, 09:18 AM
  2. Combox box Item List
    By engr_saud1 in forum Access
    Replies: 1
    Last Post: 04-04-2013, 06:50 AM
  3. List box move item up/down
    By mikael in forum Access
    Replies: 9
    Last Post: 09-12-2012, 08:49 PM
  4. Replies: 2
    Last Post: 04-05-2012, 08:39 PM
  5. Dropdown List: Use Each Item Once?
    By Heavy Doody in forum Access
    Replies: 1
    Last Post: 05-02-2011, 07:44 AM

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