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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
Back
Top