combo box not showing data

[Guest]

I have a form that shows all phone calls or allows the user to enter new
calls. cbo1 lets the user select a caller type - Media, Internal, GP.
Depending on what is chosen in that box, cbo2 displays all callers, filtered
by what is chosen in combo 1. So if "media" is chosen in cbo1, only media
names appear in cbo2. This works great while entering data! I even have it
set up that if the name doesn't appear in the list, a form pops up allowing
the user to enter the new caller, requery cbo2 & the new name appears in cbo2.

My problem occurs when I am flipping through the calls that have already
been entered using the navigation buttons on the bottom. If "media" was the
LAST chosen item in cbo1, then only media names appear in cbo2. All the
other phone calls have no data SHOWING in cbo2, even though cbo1 shows
"Internal" or "GeneralPublic". So I then re-select "Internal" in cbo1, &
Voila! the name of the internal caller magically reappears in cbo2. But now
only "Internal" names appear on the other records. Where media or GP are
displayed in cbo1, cbo2 is blank. But again, if I re-select Media in cbo1,
magically, the media caller's name for each call that pertains to media
reappear. But then the GP & Internal caller names disappear again.

The data is obviously being saved, just not displayed. Any ideas on what
I've done wrong?

 

[Guest]

Nevermind - I finally figured out a way around it. I need to requery cbo2 in
the "OnCurrent" property of the form. Thanks anyway!