Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box data disappears

Status
Not open for further replies.

Newbie456

Technical User
Nov 21, 2005
37
US
I've searched and seen threads that refer to this problem, but I can't seem to figure out the reason for it.

I have a series of combo boxes which populate based on the selection in the previous combo box. My problem is that if you select data, then move to another record, and go back to the original data, the data entered into the comboboxes which are dependent don't display until boxes are clicked on or tabbed to (SetFocus). The data's there, it just isn't displaying.

What's going on?
 
I think that this may be due to the events you are using to populate the combos. For example, have you got anything in the On Current event?
 
How are ya Newbie456 . . .

You need to requery the combo's at the right time.
Code:
[blue]   Me!ComboboxName.[purple][b]Requery[/b][/purple][/blue]

Calvin.gif
See Ya! . . . . . .
 
Yes! Thank you, I actually finally got that one on my own! (A first.) Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top