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

    Refresh control on subform (2002)

    I have a form frmVendors, lstbox lstVendors a tab control TabVendor.
    On the TabControl there are two tabs Vendor and Services in that order.
    On the Services Tab Form there is a subform 25200-frmServices-Mainform,
    In this subform is another subform 25300-frmServices-List-Entries with a lstbox lstServicesCategories.
    This is populated with Services Categorys using a query that has [Forms]![20300-frmVendors-MainForm]![lstVendors] in the VendorID Critera.
    When record is selected on the Vendor form via lstVendors the vendors services show in the subform but not in lstServicesCategories unless I physically go to it select it and then use refresh then its records come up.
    I tried using refresh in the after update event and using go to control lstServiceCategories and that works but it moves to the second tab. I use this list box to select vendors on tab 1 but it goes always to tab 2 because that is what it is supposed to do.
    I tried putting a control VendorID on the subform and when that changes to another VendorID it would refresh lstServicesCategories but nothing seems to work i.e on change, dirty ect.
    Frank <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Refresh control on subform (2002)

    You need to specifically requery lstServicesCategories rather than refreshing it.
    Charlotte

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

    Thanks Will Do.

    Thanks Will Do.
    Frank

Posting Permissions

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