Combo Boxes & Requery Issues

[Mani]

Hi! Please Help me!! I have a form with a subform with data... I have 4
combo boxes that are synchronized. Combo1 (Beginning Status), Combo2 (Grade
Level), Combo3 (Secondary School), and Combo4 (Ending Status). Alright so
when I click on Combo1 it gives me multiple options... so I select one option
and based on option from Combo1 the Combo2 populates certain options....
Ok... so I did requery for that to happen, so all works well. Except for one
particular option.. that one doesn't refresh or requery like it's suppose to.
Why is that???? Does this make sense?? Please help me ASAP!!!!

 

[Beetle]

Can you post the SQL of the Row Source of each of
your combo boxes?

 

[Gina Whipp]

Mani,

Refreash or requery like it's suppose to doesn't give us much to go on. We
don't know what is suppose to show. A wee bit more information. The SQL of
each combo will help, along with some sample data, such as...

Combo one = State
Combo Tow = All cities in the the state (filtered via Combo 1)
etc...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm