Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Unanswered: Listbox help access 2000

    I'm loading a listbox with a query but I need the the query to rerun after update. In the After update box I set it to run query but that doesn't seem to work. Can someone point me in the right direction?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    me.refresh
    mylistboxcontrol.requery
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    Does that go into After update or into Private Sub List310_AfterUpdate() ???

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Let me grab my crystal ball....

    I need the the query to rerun after update.
    Update of what?

    Does that go into After update or into Private Sub List310_AfterUpdate() ???
    Exactly how is it you expect us to know? All I know at this point is that List310 is badly named and you use the term "after update" WAAAAYYY too loosely.

    Pick one and try it. If it doesn't work, try the other one. That's all I can suggest.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jul 2009
    Posts
    3
    In the list box properties box there is an event called "After update", it would seem to me they should go into into Private Sub List310_AfterUpdate() because it likes like VBA but that doesn't work. I took the following code from the Microsoft website and it works if I make it a button but not if I put it into the AfterUpdate sub. Any Ideas?

    Dim ctlCombo As Control

    ' Return Control object pointing to a combo box.
    Set ctlCombo = Forms!DEMOGRAPHICS!cohorts

    ' Requery source of data for list box.
    ctlCombo.Requery

    Thanks for all the help....
    Attached Thumbnails Attached Thumbnails listbox.JPG  
    Last edited by Jmg810; 07-13-09 at 01:43.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •