locked
Update list box the query value RRS feed

  • Question

  • hi,

    I have a form with a list box that takes a value from a query.

    How do I update the list box .

    now i need to click to update the list box.

    Thanks'

    golan


    golan
    Tuesday, September 6, 2011 5:40 PM

Answers

  • Hi Golan,

     

    Try the .Requery property of the Listbox in the On Load event of your Form:

    Me.lstYourListBoxName.Requery
    

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Proposed as answer by danishani Tuesday, September 13, 2011 11:26 PM
    • Marked as answer by Bruce Song Monday, September 19, 2011 7:03 AM
    Tuesday, September 6, 2011 5:49 PM
  • I think you need to be more specific.

    me.listbox.requery will update the list based on changes in query data


    For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ...Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. - Mark Twain
    • Proposed as answer by danishani Tuesday, September 13, 2011 11:26 PM
    • Marked as answer by Bruce Song Monday, September 19, 2011 7:03 AM
    Tuesday, September 6, 2011 5:50 PM

All replies

  • Hi Golan,

     

    Try the .Requery property of the Listbox in the On Load event of your Form:

    Me.lstYourListBoxName.Requery
    

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Proposed as answer by danishani Tuesday, September 13, 2011 11:26 PM
    • Marked as answer by Bruce Song Monday, September 19, 2011 7:03 AM
    Tuesday, September 6, 2011 5:49 PM
  • I think you need to be more specific.

    me.listbox.requery will update the list based on changes in query data


    For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ...Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. - Mark Twain
    • Proposed as answer by danishani Tuesday, September 13, 2011 11:26 PM
    • Marked as answer by Bruce Song Monday, September 19, 2011 7:03 AM
    Tuesday, September 6, 2011 5:50 PM