Combo Box

[Guest]

I created 2 combo boxes, the first one I called it as "Phase" and the second
as "Task". I set Row Source for "Task" to "SELECT Task FROM Task WHERE
Phase=FORMS![Add Task]!Phase;". So, a possible values for "Task" is dependent
on the value selected in "Phase" combo box. "Phase" would always present the
correct values for the FIRST value selected for "Phase". However, "Task"
would display the SAME SET of values even though a different value from
"Phase" has been selected. Note: I have confirmed that each "Phase" value has
different set of records.

Can anybody suggest a solution ? Thanks.

 

[Guest]

In the After Update event of your Phase combo box put;

Me![NameOfYourTaskCombobox].Requery

HTH

 

[Guest]

Beetle, it works. Thank you much. - JJ

In the After Update event of your Phase combo box put;

Me![NameOfYourTaskCombobox].Requery

HTH

I created 2 combo boxes, the first one I called it as "Phase" and the second
as "Task". I set Row Source for "Task" to "SELECT Task FROM Task WHERE
Phase=FORMS![Add Task]!Phase;". So, a possible values for "Task" is dependent
on the value selected in "Phase" combo box. "Phase" would always present the
correct values for the FIRST value selected for "Phase". However, "Task"
would display the SAME SET of values even though a different value from
"Phase" has been selected. Note: I have confirmed that each "Phase" value has
different set of records.

Can anybody suggest a solution ? Thanks.