468,317 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,317 developers. It's quick & easy.

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.
Nov 13 '05 #1
1 1651
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by franc sutherland | last post: by
1 post views Thread by howard w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.