If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Boxes & Requery Issues
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!!!! |
#2
|
|||
|
|||
Combo Boxes & Requery Issues
Can you post the SQL of the Row Source of each of
your combo boxes? -- _________ Sean Bailey "Mani" wrote: 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!!!! |
#3
|
|||
|
|||
Combo Boxes & Requery Issues
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 "Mani" wrote in message ... 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!!!! |
Thread Tools | |
Display Modes | |
|
|