Combo boxes not refreshing when a value is chosen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I am having trouble with my combo boxes not refreshing the data I select.
When I go into the form the first time, it works as intended, but when I
change a box and go to the next combo box, the previous selections are there.
I know that the queries are right in the combo boxes, and all 3 combo boxes
are unbound. Anyone have any ideas?
 
Eric,
You wote...
When I go into the form the first time, it works as intended...
Click to expand...
What is "as intended?" We'll need to know what that combo, and any realted
combos, are supposed to do in order to give a reasonably accurate answer.

Are you selecting a value in Combo1 and using that value to filter Combo2?
If so, you'll need to do a Requery on Combo2 when the Combo1 AfterUpdate
event occurs.
Unbound combo boxes will retain the last entered value as you move from
record to record. That's normal for an unbound control. Use the OnCurrent
event of the form to "clear" the values of those combos, and requery them as
necessary.
hth
Al Camp
 
Back
Top