Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

How do I Synchronize or filter a Combo Box without Code?

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

  1. Christian >

    Christian >
    Expand Collapse
    Guest

    My combo box [named categories] in table 3 [orders table] is based on table 1
    [categories table].
    My combo box [named products] in table 3 [orders table] is based on table 2
    [products table].

    This is what I want: When you select a category name in the first combo
    box, the second combo box is filtered to list only the product names for that
    category.

    I found a process for that here using code:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

    It doesn't explain it. I have been able to duplicate it in my orders form.
    It only works in combo boxes in forms.

    Questions:
    Is there are way to do it in the tables?
    Is there a way to do it without code?
    What the heck does "me !" mean at the beginning of the code?
     
  2. Loading...

    Similar Threads Forum Date
    General Filter Test Hard Talk May 20, 2008

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Me is another way of pointing to current form, page, report, etc
    so instead of writing
    [Forms]![ChristiansPage]![Combo1]
    you would simply put
    Me.Combo1


    --
    Wayne




    "Christian ><>" wrote:

    > My combo box [named categories] in table 3 [orders table] is based on table 1
    > [categories table].
    > My combo box [named products] in table 3 [orders table] is based on table 2
    > [products table].
    >
    > This is what I want: When you select a category name in the first combo
    > box, the second combo box is filtered to list only the product names for that
    > category.
    >
    > I found a process for that here using code:
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
    >
    > It doesn't explain it. I have been able to duplicate it in my orders form.
    > It only works in combo boxes in forms.
    >
    > Questions:
    > Is there are way to do it in the tables?
    > Is there a way to do it without code?
    > What the heck does "me !" mean at the beginning of the code?
     
  4. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    1) You shouldn't need to do it with tables: you should never be working
    directly with the tables.

    2) To ensure that the content of the combo box changes as appropriate, you
    need some code. See
    http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx for another
    approach.

    3) As it states in the Help file, "The Me keyword behaves like an implicitly
    declared variable....Me provides a way to refer to the specific instance of
    the class where the code is executing." When associated with a form, it's a
    way of indicating what form Access should look on to find the control. The
    alternative would be to hard-code the form name as Forms!MyForm!MyControl,
    as opposed to simply Me!MyControl.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Christian ><>" <Christian@discussions.microsoft.com> wrote in message
    news:4109D7B3-3AA9-451B-A558-0A6A1CFAA733@microsoft.com...
    > My combo box [named categories] in table 3 [orders table] is based on
    > table 1
    > [categories table].
    > My combo box [named products] in table 3 [orders table] is based on table
    > 2
    > [products table].
    >
    > This is what I want: When you select a category name in the first combo
    > box, the second combo box is filtered to list only the product names for
    > that
    > category.
    >
    > I found a process for that here using code:
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
    >
    > It doesn't explain it. I have been able to duplicate it in my orders
    > form.
    > It only works in combo boxes in forms.
    >
    > Questions:
    > Is there are way to do it in the tables?
    > Is there a way to do it without code?
    > What the heck does "me !" mean at the beginning of the code?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page