Cascading combo boxes on continuous subform

[Lynn]

I have 2 combo boxes on a continuous subform. The values
in the second combo box are dependent on what they choose
in the first combo box.

The record source for both combo boxes are stored
procedures.

The problem is that I can't get the 2nd combo to requery
on the current record only. It requeries all of the
records on that continuous subform and overrides the data
in the other records to null.

 

[Lynn]

OK, I got the requery to work . . . it was actually
working before but it didn't look like it because in the
combo box there are 4 fields.

I am binding the first field but not showing it in the
combo box. The 2nd field shows the last 4 digits of the
1st field. The problem is that in the continuous form the
combo box does not show the value of the 2nd field unless
you move the cursor to that record on the continuous form.

Hope this made sense. Any help would be appreciated.