Results 1 to 3 of 3
  1. #1
    avalentini is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2018
    Posts
    9

    Allow multiple values and allow value list edits using a combo box that has a query as its source


    I'm trying to have a field that is a Combo Box and fulfills the following criteria:
    (1) Allows multiple values
    (2) Allows value list edits
    (3) Can be sorted alphabetically.

    I find that I can only achieve 2 out of the 3 with any given solution.

    Attempt 1
    Row Source Type = Value List
    Row Source = a;b;c
    Allow Multiple Values = Yes
    Allow Value List Edits = Yes
    Fulfills Criteria 1 and 2 but not 3

    Attempt 2
    Row Source Type = Table/Query
    Row Source = Query
    Allow Multiple Values = Yes
    Allow Value List Edits = Yes
    Fulfills Criteria 1 and 3 but not 2

    Does anyone know if this is possible, or am I trying to achieve too much at once?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    1. You want to use multi-value field?

    2. I have never used dynamic Value List. This would require modifying the form RowSource property and saving the modified form design. Exactly how are you modifying the list to include the new item next time form is opened? This list will grow infinitely?

    3. If you want them alphabetical then have to list them alphabetical.


    Better to use a table as RowSource and allow adding new items to table using NotInList event. Although, not sure how this would work with multi-select combobox because I never use multi-value field.
    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.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    This DB will do what you want, except it is a listbox and no MVF's.
    Right click on the listbox to bring up a form that will allow edits.

    If you are using mutti-value table fields, give details and we can suggest alternatives.
    Last edited by davegri; 09-22-2018 at 09:30 PM. Reason: MVF verbiage

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

Similar Threads

  1. Replies: 1
    Last Post: 03-19-2016, 03:56 AM
  2. Replies: 2
    Last Post: 02-26-2015, 03:20 PM
  3. Replies: 8
    Last Post: 10-13-2014, 02:44 PM
  4. Replies: 1
    Last Post: 09-11-2014, 05:53 AM
  5. Replies: 1
    Last Post: 03-01-2011, 03:04 PM

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
  •  
Other Forums: Microsoft Office Forums