Combo boxes not refreshing when a value is chosen

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?
 
A

Al Camp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refresh combo boxes on form 6
refreshing combo box on subform 1
Combo Box, Unbound Text Boxes 2
synchronized Combo Boxes in subforms 2
Cascading Combo Boxes in a continuous subform 1
Cascading Combo Boxes and Populating a Form 3
my combo boxes 2
Combo Boxes & Filtering Value 4

Top