Results 1 to 2 of 2
  1. #1
    AllegraAccess is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Posts
    6

    Execute Query on List Box change


    I have a list box (1L) in a form (1F) that list member IDs from a table. Then I have a query (1Q) that use (1L) member ID to get data from a table another related table. When I change the 1L and run the query 1Q the results is correct. So I added a new list box (2L) in form 1F that show the results of the query. When I open the form 1F the 2L is populated correctly by the query. Here is my problem. I need to have list 2L update when I change 1L. Here is what I did. I created an On Change event for 1L that has a code Me.2L.Requery, but nothing happens.

  2. #2
    AllegraAccess is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Posts
    6
    For some reason Access disabled this function. I noticed a warning about it. When I enabled it the function worked.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-21-2013, 10:40 AM
  2. Replies: 2
    Last Post: 02-07-2012, 08:38 PM
  3. Replies: 3
    Last Post: 01-18-2012, 12:26 AM
  4. Replies: 3
    Last Post: 12-23-2010, 10:23 AM
  5. List box not reflecting change on a form
    By vladimir.tz in forum Forms
    Replies: 7
    Last Post: 05-06-2010, 03:37 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