Results 1 to 2 of 2
  1. #1
    crookie is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Sep 2012

    Problem: ComboBox selection populates ListBox --> Clicking ListBox loads record


    I will try and keep this brief and concise. I have been scratching my head for hours now..

    I have two tables. One is a one-column list of names. The other is a list of parts and details and the owner of each part (from the list of names).

    On my form, I start with a ComboBox which displays the list of names. When I choose a name, it then populates a ListBox with all of the parts associated with that person. When I select a part in the ListBox, I would like the form to load that record and populate many fields with all of the data from the record, for review or editing.

    Unfortunately that last step doesn't work for me, UNLESS I right-click on the form and select "Remove Filter/Sort". I have no idea why choosing that works, but as soon as I do, I can click parts all day long on the ListBox and the correct data is displayed in the rest of the fields, and is saved properly if I edit it.

    Please, help would be GREATLY appreciated.

    I can post my DB too if necessary.. Access 2000.


  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Would need to review code. Post it or provide db for analysis. Follow instructions at bottom of my post. Identify the objects involved in the issue.
    How to attach file: 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: 7
    Last Post: 04-18-2012, 11:38 AM
  2. Replies: 1
    Last Post: 02-01-2012, 11:27 PM
  3. Deleting a ListBox Selection
    By dreamnauta in forum Programming
    Replies: 4
    Last Post: 01-27-2012, 03:14 PM
  4. Cancel Selection Event for ListBox
    By is49460 in forum Forms
    Replies: 2
    Last Post: 08-04-2010, 05:53 PM
  5. Cancel listbox selection
    By vba-dev in forum Access
    Replies: 0
    Last Post: 10-26-2009, 12:18 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