Related Combo Boxes on a Continuous Form

[gaffonso]

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

 

[KiwiRex]

The reason is: InternallY, there's only one real control - the one on the current record. All the rest are just painted there, until you move to it.

The work around that I used was to include the field that's displayed in the combo box in the query that the form is based on.
Have a text box that displays it, and it goes right on top of the combo box.
In the on enter event of the text box, set focus to the combo box.

Bit difficult to describe, but it works.

Cheers,