Results 1 to 3 of 3
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Combo box with multiple entry but cannot be changed

    I have created a combo box that can accept multiple entry and saved in a table in 1 location.

    the problem i have encountered is that when i tried deleting the previous entry and replace with another entry or add another, it is no longer accepting.

    Sample:

    1 Orig-Invoice
    2 Delivery Note
    3 Quantity Sheet
    4 Transfer Form


    5 Approved Invoice

    My early entry was: 1, 2 and 3

    I unchecked entry 1, 2 and 3 and checked number 5.

    the error i got was Record is Deleted. When I press OK the original entry returns.

    Can you please help me on this.

    thank you.

    Trident

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    sounds like you are using a multivalue field? You will need to provide some more information - what is the field structure for the table where the field is, what is its releationships to other tables, what is the rowsource to the combobox? Is there any code/macros associated with the combobox? What is the full error message? Has this always happened or just started (in which case check relevant records have not been deleted) Multivalue fields have limited capabilities and it may be you are not using correctly

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    I agree with Ajax. Suggest you look at this post for ideas.
    I would not use multi-valued field MVF.
    Multi select listbox would be my choice, but you know your requirements better than readers..

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

Similar Threads

  1. Combo Box add new entry
    By ZJGMoparman in forum Programming
    Replies: 1
    Last Post: 04-10-2012, 08:32 PM
  2. Entry is too long for Combo box
    By EinSpringfielder in forum Forms
    Replies: 1
    Last Post: 03-08-2012, 09:27 AM
  3. keeping current entry in field until changed
    By Chazcoral in forum Forms
    Replies: 16
    Last Post: 09-09-2010, 12:01 PM
  4. Replies: 7
    Last Post: 05-29-2009, 04:27 PM
  5. restricting combo box entry
    By fairlo in forum Forms
    Replies: 1
    Last Post: 10-04-2007, 04:05 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