G
Guest
Hi all, I get stucked on the following.
I have a form for data input where there are two combo box .
1st combo box is to input customer code (from Customer Query)
2nd combo box is to input Merchandiser name (from Merchandiser Query, using
the input at 1st combo box as the criteria)
The problem come when:
I enter a customer code for 1st combo box, say ABC
Then I move to the 2nd combo box which display a list of merchandiser
working for ABC company, say Simon, Peter, Mary etc.
Then I find the company is wrong so I go back to 1st combo box to correct it
to XYZ.
Then I go the the 2nd combo box to expect a revised merchandiser list of XYZ
company,
but the list is still those of ABC Company,
i.e., the underlying query still refers ABC, not the new one.
So my question is how to make the 2nd combo box to response to change of
data in 1st combo box and revise the merchandiser list from ABC company to
XYZ company?
Grateful if someone can help me to sort it out.
Best regards
Simon Wong
I have a form for data input where there are two combo box .
1st combo box is to input customer code (from Customer Query)
2nd combo box is to input Merchandiser name (from Merchandiser Query, using
the input at 1st combo box as the criteria)
The problem come when:
I enter a customer code for 1st combo box, say ABC
Then I move to the 2nd combo box which display a list of merchandiser
working for ABC company, say Simon, Peter, Mary etc.
Then I find the company is wrong so I go back to 1st combo box to correct it
to XYZ.
Then I go the the 2nd combo box to expect a revised merchandiser list of XYZ
company,
but the list is still those of ABC Company,
i.e., the underlying query still refers ABC, not the new one.
So my question is how to make the 2nd combo box to response to change of
data in 1st combo box and revise the merchandiser list from ABC company to
XYZ company?
Grateful if someone can help me to sort it out.
Best regards
Simon Wong