Results 1 to 4 of 4

Can a single row in a list box be changed?

  1. #1
    S2000magician is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    31

    Can a single row in a list box be changed?

    If so, how, if you please?

    I've hunted round and cannot find anything that addresses this idea.



    As always, thanks for your help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    47,842
    The source data has to be modified. If the RowSource is a table or query then data in table must be changed and the listbox requeried.

    Why do you ask? What exactly are you trying to accomplish?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    S2000magician is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    31
    Quote Originally Posted by June7 View Post
    The source data has to be modified. If the RowSource is a table or query then data in table must be changed and the listbox requeried.

    Why do you ask? What exactly are you trying to accomplish?
    The user needs to create an investment portfolio, which requires a list of securities and a percentage of the portfolio held in each security.

    The securities can be selected from another list box, but then the user has to input the percentage for each security. I thought that if it were possible to change a single row in a list box, I could put the selected securities in a (new) 2-column list box and have the user edit the percentages in the second column.

    Because I don't know how many securities the user will select, I thought that a 2-column list box would be the best approach. However, if you have another approach that's better, I'm all ears.

    Thanks!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    47,842
    User cannot edit combobox or listbox items directly. Shouldn't selection of securities be saved as records to a table and user enters percentage into each record? This is data entry.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-06-2016, 12:57 PM
  2. Replies: 1
    Last Post: 09-10-2015, 04:19 AM
  3. Replies: 2
    Last Post: 03-20-2015, 06:30 AM
  4. Single list with different fields
    By Douglasrac in forum Reports
    Replies: 7
    Last Post: 04-12-2011, 04:36 PM
  5. combining fields into a single list
    By rich in forum Queries
    Replies: 4
    Last Post: 02-23-2009, 06:41 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
  •  
Tech Forums: Microsoft Office Forums