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!
Thank you!