Results 1 to 3 of 3
  1. #1
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121

    Delete selection from list box on subform

    Hello,



    I have a subform that allows users to select values from a list box. They want to be able to delete the value if they change their mind, but it does not seem to allow it only allows user to change selection. How can I get it to allow delete?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,411
    you will need an event to run the code

    me.listboxname=null

    that event might be a a double click on the listbox, a click event on a button, or perhaps a messagebox that confirms ok to continue. which is most appropriate will depend on how your form and users work

  3. #3
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121
    Great, thank you!

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

Similar Threads

  1. Get List Box Selection From VBA
    By jo15765 in forum Modules
    Replies: 3
    Last Post: 08-16-2016, 09:13 AM
  2. Multiple selection list box
    By Thompyt in forum Programming
    Replies: 6
    Last Post: 03-23-2015, 08:26 AM
  3. Replies: 4
    Last Post: 07-03-2013, 10:02 AM
  4. Replies: 9
    Last Post: 10-16-2012, 07:51 AM
  5. Selection List for Query
    By Juan4412 in forum Queries
    Replies: 13
    Last Post: 01-09-2011, 05:59 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