Results 1 to 3 of 3
  1. #1
    cfgrs is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Jan 2013

    Remembering multiselect listbox selections for a record, and re-selecting it?

    Hello everyone,

    So I have a multiselect listbox. The list that it shows depends on what is selected in a separate combo box.

    I want to be able to select multiple items from the listbox, and then be able to leave the record, and when I come back to it, to still have those items highlighted. Right now in my form, as I go through records, if I highlighted items 1,2 and 3 on a record, those first three lines will stay highlighted as I move through different records, rather than changing to what had been selected for each record.

    I've already stored the actual selected values in a subtable. I just want to have it highlighted again so that you can see what was previously selected.

    Any advice? Thank you!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    This is an unbound listbox - not storing data into a multi-value field? Need code that will select items in listbox RowSource. Place code in form Current event. Unfortunately, I don't know the exact code to programmatically select multiple items in a listbox. It would probably involve opening a recordset and looping through the recordset to get each value and also looping through the listbox list to locate the matching value and set Selected property for row to True.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012

    you can do this. The url takes you to how to code the and use the selections in code. You can reverse engineer it to use this. If you have the record ID's of the ones

    try going to each record and using this to mark the record.. Docmd.RunCommand acCmdSelectRecord

    I hope this helps

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

Similar Threads

  1. Multiselect Listbox
    By wwhit in forum Forms
    Replies: 19
    Last Post: 03-09-2015, 02:58 PM
  2. Replies: 1
    Last Post: 01-28-2013, 10:55 PM
  3. Listbox multiselect status
    By Sam23 in forum Programming
    Replies: 5
    Last Post: 03-06-2012, 01:13 PM
  4. multiselect listbox - search result problem
    By svartisya in forum Forms
    Replies: 4
    Last Post: 11-29-2011, 07:17 AM
  5. Append Records using MultiSelect Listbox
    By Ted C in forum Programming
    Replies: 14
    Last Post: 03-15-2011, 01:25 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 - Senior Forums