Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List Box Refresh? (2002)

    I have a main form frmVendors
    A tab control TabVendor with two tabs: Vendors and Services.
    On the second tab I have a subform:25100-frmServices-MainForm-Tab.
    Within this subform is another tab form TabServices.
    On this tab form is another subform: 25300-frmServices-List-Entries
    On this tab form is a list box lstServicesCategories which when selected pulls up a different category of services.
    I have a query with a parameter [Forms]![20300-frmVendors-MainForm]![lstVendors].
    Everything works well except the list box needs to be refreshed each time a selection changes on lstVendors.
    I tried putting refresh code in the lstVendors but you go to tabServices even when you are on tabVendors.
    Help!
    Frank

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: List Box Refresh? (2002)

    You wrote:
    >>Everything works well except the list box needs to be refreshed each time a selection changes on lstVendors.
    I tried putting refresh code in the lstVendors but you go to tabServices even when you are on tabVendors.<<

    I don't understand your problem. Did lstServicesCategories refresh?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Box Refresh? (2002)

    Yes but it was very sloppy as it selected the list box way down through the subforms and did not look good as the form blinked each time lstvendors was selected.
    Frank

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: List Box Refresh? (2002)

    What did you actually do to refresh that listbox? Did you change the focus? Did you refresh the subform that the listbox was on? Or, preferably, did you just use the .Requery method against that listbox directly?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Works Now!

    Your requery method was spot on.

    Forms![60300-frmJobCost-MainForm]![65100-frmSales-MainForm]![65500-frmSalesInvoice]![lstSalesInvoices].Requery

    Frank <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>

Posting Permissions

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