Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating the content of a listbox (MS Access2007)

    On a form i have a listbox "lstArticles" who's recordsource is a query that shows all articles that are in stock. "Qty > 0"
    if for some reason one of the articles who wasn,t in stock anymore is brought back in stock, the result of this must be reflected immediately in the listbox when the form will be opened again.
    In the event "On load "of the form if have put the code : me!lstArticle.requery . However, i found out that this doesn't help. Sometimes i have to open the form more than ones before the content of the listbox is reflecting this change. What can I do to solve this problem ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updating the content of a listbox (MS Access2007)

    Is this related to <post:=748,097>post 748,097</post:> and following?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating the content of a listbox (MS Access2007)

    yes

    Greetings

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updating the content of a listbox (MS Access2007)

    In the other thread you mentioned that the form doesn't get closed, only hidden. So the On Open and On Load events aren't appropriate here. Try the On Activate event of the form.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating the content of a listbox (MS Access2007)

    Hans thank you very much for the effort to help me !!!

Posting Permissions

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