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

[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?

 

[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

 

[Douglas J. Steele]

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.