I've got two combo boxes on a continuous form. The first combo box determines what appears in the second. This is currently done by creating a SQL query as the recordsource for the second combo box and having that query reference the value of the first combo box.
As you probably know, this technique fails on a continuous form. It appears as if the combo box query is run once and then never again. *All* of the 2nd combo boxes on the continuous form have the same list of values.
Can someone please explain why this is? Is there any way around it?
Thanks!
- Gary
As you probably know, this technique fails on a continuous form. It appears as if the combo box query is run once and then never again. *All* of the 2nd combo boxes on the continuous form have the same list of values.
Can someone please explain why this is? Is there any way around it?
Thanks!
- Gary