filling combo box based on previous combo

[JRT]

I have a continuous form with 3 comboxes, combo1, combo2 combo3. The
choices in combo2 are dtermined the what is selected in combo1 by using a
where = combo1 statement. The combo is refreshed with code, i.e. . The
combo are freshed with code on after update of previous combo. SO combo1
after update might be me.combo2.requery. It works well to fill in the combo
box with the choices, but problem is when I go down to the next record in
the continuous form and select comb1 record 2 it requeries and removes the
data from combos in record 1. Any body have any ideas here..there must be a
simple fix to this.

tia for anyone who can help me with this.

[Trevor Best]

JRT wrote:

I have a continuous form with 3 comboxes, combo1, combo2 combo3. The
choices in combo2 are dtermined the what is selected in combo1 by using a
where = combo1 statement. The combo is refreshed with code, i.e. . The
combo are freshed with code on after update of previous combo. SO combo1
after update might be me.combo2.requery. It works well to fill in the combo
box with the choices, but problem is when I go down to the next record in
the continuous form and select comb1 record 2 it requeries and removes the
data from combos in record 1. Any body have any ideas here..there must be a
simple fix to this.

tia for anyone who can help me with this.

First off, don't panic, it doesn't remove data, the values of the
previous records are preserved, just not displayed.

One thing I used to do was to make a union query or additional criteria
where the id in (select id from mysubform...). This gets the previous
values displayed but introduces the ability to select an out of range
value on the new ones.

What I do now is place a textbox on top of the combo and lookup the
value from the table in it's controlsource.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer