By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

filling combo box based on previous combo

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.