issue in populating combo box based on another combo box

[selvakumar.arc]

Hi All,



In my application I have 2 combo box. I have to populate 2nd combo box value based on 1st combo box. This scenario is working first time but subsequent data fetching is failing. For Example
1st combo box - Form No
2nd combo box - EdDt

Form No EdDt
ABCD 0001
ABCD 0002
ABCD 0003
WXYZ 0004
WXYZ 0005

If user select 1st combo box value as "WXYZ" then 2nd combo box should populate as 0004/0005 and if user select ABCD then it should display 0001/0002/0003/0004. This scenario is working in first time but in second time user tries to modify the EdDt then application showing EdDt for the first selected Form No.
For example I have 2 records in my application
ABCD 0002
WXYZ 0004
If the user select "WXYZ" - EdDt then 2nd combo box displaying 0004 and 0005. But if the user select "ABCD" - EdDt then application showing EdDt as 0004/0005 instead of 0001/0002/0003/0004.
This case combo box is not refreshing based on its Form No.
Please help me to solve this issue.

[June7]

What is the SQL of the second combobox RowSource?

Do you have code in the first combobox AfterUpdate event to requery the second combobox?