Results 1 to 3 of 3

Is it possible to search a combo box that references a table that allows multiple value selections?

  1. #1
    petermazza is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    1

    Is it possible to search a combo box that references a table that allows multiple value selections?

    Hi! First time posting here



    I am trying to create a searchable list of barcode numbers in a form. The barcode numbers would be pulled from my Inventory table, where the Barcode field has "Allow Multiple Values" on Yes. It's my understanding that you can only search a combo box if it allows one selection, not multiple? Or is there a way around this?

    Thanks

    Peter

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,438
    there are a number of ways you can do this

    1. When you use your combo box have a button to 'add' it, add the bar code to a temporary table, then when you run your query link the temporary table to your table holding the data
    2. Use a multi select list box instead of a combo box, then run something similar to suggestion 1 just adding a bunch of bar codes at once instead of 1 at a time by cycling through selected items in a list box. something like:

    Code:
    with LISTBOXNAME
        for i = 0 to .listcount -1 '(use i = 1 if your list box does not have column headers turned on)
            if .selected(i) then
                'append the value to the temp table
            endif
        next i
    end with

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,345
    It sounds like you have a field in a table defined as a Multi-Value Field. Most experienced developers do not use MFVs.

    For an explanation of why you shouldn't use them, see http://www.mendipdatasystems.co.uk/m...lds/4594468763
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Multiple Selections in a Combo Box
    By BeStout in forum Access
    Replies: 6
    Last Post: 07-09-2014, 12:44 PM
  2. Replies: 21
    Last Post: 06-13-2013, 06:51 AM
  3. Replies: 3
    Last Post: 01-21-2013, 12:57 AM
  4. Replies: 5
    Last Post: 01-15-2013, 01:27 PM
  5. Replies: 2
    Last Post: 05-27-2011, 08:12 AM

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