Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Set filter on a subform

Discussion in 'Information Technology' started by Francophone, Jul 28, 2006.

  1. Francophone

    Francophone
    Expand Collapse
    Guest

    How can I set the filter on a subform after the user updates a value on the
    main form. For instance, when the user chooses a customer on the main form,
    I'd like the subform to display transactions by that customer. Problem is, I
    have to consolidate several customers (ie. JoeDiner-West, JoeDiner-East) who
    have separate Customer IDs. Therefore, I think I need to do this in VB in
    the after event of the "choose customer" control.

    Any suggestions?

    TIA
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Settlement Leads To Peaceful Transition At Sikh Temple Breaking News Sep 10, 2016
    Sikhi Langar-Aid - Sikhs Have Set Up A 'Langar' In The ISIS Territory of Syria To Feed Refugees Sikh Sikhi Sikhism Oct 31, 2015
    A set back or a step forward Blogs Oct 17, 2015
    USA Sikh Cartoonist Sets Out To Fight Racial Bias Breaking News Mar 9, 2015
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    how about adding a MainCustomer Field to the table with a selfjoin between
    This & CustomerID?
    Then you could consilidate using this field instead

    HTH

    Pieter

    "Francophone" <Francophone@discussions.microsoft.com> wrote in message
    news:82DD9AB5-EBFC-462D-9FFB-8048D7672A54@microsoft.com...
    > How can I set the filter on a subform after the user updates a value on
    > the
    > main form. For instance, when the user chooses a customer on the main
    > form,
    > I'd like the subform to display transactions by that customer. Problem
    > is, I
    > have to consolidate several customers (ie. JoeDiner-West, JoeDiner-East)
    > who
    > have separate Customer IDs. Therefore, I think I need to do this in VB in
    > the after event of the "choose customer" control.
    >
    > Any suggestions?
    >
    > TIA




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4285 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page