Welcome to SPN

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

Sign Up Now!

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?
     

Share This Page