Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    23

    Problems with a query in a list box


    I am having problems with a list box that the row source is a query. The list box is not refreshing the query results. The query is changing every time it is executed but the list box displays the records extracted the first time it was populated. Can anyone help on this. Thanks.

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Requery the control:

    Me![MyList].Requery

    You could do this, for example, in the OnCurrent event for the form, or the OnGotFocus event for the control.

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

Similar Threads

  1. Problems with list or combo box on tabbed form
    By kydbmaster in forum Forms
    Replies: 0
    Last Post: 02-20-2008, 01:33 AM
  2. Problems with run permissions on a query
    By admaldo in forum Queries
    Replies: 0
    Last Post: 05-09-2006, 09:04 AM
  3. Replies: 0
    Last Post: 04-21-2006, 08:21 AM
  4. Replies: 0
    Last Post: 04-21-2006, 06:55 AM
  5. Query List
    By sanjshah in forum Queries
    Replies: 3
    Last Post: 03-25-2006, 08:01 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
  •  
Tech Forums: Microsoft Office Forums