Results 1 to 5 of 5
  1. #1
    Cedarguy is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    May 2012
    Posts
    37

    How to retain values selected in a listbox

    I have a form with a table and 2 list boxes.

    The table is a child to the 2 tables the listboxes pertain to.

    Selecting a value in the listboxes populates the selected fields in the table on the form.



    It all works as expected EXCEPT

    After the record is added to the table and the next blank one comes up, the values in the listboxes are no longer selected. I need to reuse the selected values on multiple records.

    Is there a way Access can accommodate this?

    Thanks

  2. #2
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    Check out the "Duplicate" function on frmInventory in the database I attached. It will duplicate whatever row you select in the form but will not save until you change the data in the Primary Key.
    Hope that helps.
    Attached Files Attached Files

  3. #3
    Cedarguy is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    May 2012
    Posts
    37
    Thanks TG_W; will try this out

  4. #4
    Cedarguy is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    May 2012
    Posts
    37
    Thanks again TG_W; works beautifully; regards

  5. #5
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    Great! Glad I could help.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-13-2012, 08:14 AM
  2. Replies: 3
    Last Post: 02-01-2011, 09:47 AM
  3. Data Entry Form: Retain Selected List Box Value
    By William McKinley in forum Forms
    Replies: 1
    Last Post: 11-05-2010, 10:14 AM
  4. Selected items in listbox
    By tomodachi in forum Access
    Replies: 1
    Last Post: 09-09-2010, 01:14 PM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 AM

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