Access creates the filter functions.

[llgtjb001]

I have a problem. I created a form to display three combo boxes: form1, form2, form3. The form1 show the "A series, B series, C series, etc"(from query resource).The problem is form2 because I want to filter some conditions that base on form1, such as if form1 has "a series", the form2 only show the ab, ac, ad as brand as a series. It does not show other options, such as b series. How to filter this? What function should I use, such as dlookup?
Thank you.

[pbaldy]

As suggested elsewhere,

http://www.baldyweb.com/CascadingCombo.htm

[llgtjb001]

As suggested elsewhere,

http://www.baldyweb.com/CascadingCombo.htm

Thank you! I got it. I have to reply you with 10 words.

[pbaldy]

No problem.